Solved

What is this 'Comment'-like pop-up feature in Excel ?

Posted on 2015-02-10
6
57 Views
Last Modified: 2016-02-10
Hi All,

I've just come across a feature in Excel which I've never seen before. When I click on a cell it displays as a pop-up box with comment-friendly text inside. The pop-up can be dragged around the sheet but I can't find a way of editing the text or deleting it completely. If I click off the box, it hides.

It's not a Comment because I can insert and edit one of those in the same cell as the pop-up.

I've attached a PNG of it.

Thanks
Toco
Excel-comment-like-feature.PNG
0
Comment
Question by:Tocogroup
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
6 Comments
 
LVL 11

Expert Comment

by:Wilder1626
ID: 40600710
Hi,

This looks like a PopUp Input message created VBA.

When you go on a cell selection, it automatically show the InputBox.

Is this a VBA macro excel file?

ex:
 .InputTitle = "Reporting Period Start Date"
     .InputMessage = "The start date of the reporting..."

Open in new window

0
 
LVL 11

Expert Comment

by:Wilder1626
ID: 40600758
Here is an example i did
input message
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim r As Range
Set r = Intersect(Target, Range("C1:C" & Rows.Count))
If Not r Is Nothing Then

With r.Offset(, 0).Validation

 .Add Type:=xlValidateInputOnly
  .InputTitle = "Reporting Period Start Date"
     .InputMessage = "The start date of the reporting..."
     End With

 End If
End Sub

Open in new window

Input-message.xlsm
0
 
LVL 33

Expert Comment

by:Rob Henson
ID: 40600759
It could also be the message box from the Data Validation Function.

Thanks
Rob H
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 11

Expert Comment

by:Wilder1626
ID: 40600773
Rob is also correct.
You would have access to it by just following below picture:
Input box
0
 
LVL 33

Accepted Solution

by:
Rob Henson earned 500 total points
ID: 40600789
Thanks WIlder, I was working on screen shots to explain.
0
 

Author Closing Comment

by:Tocogroup
ID: 40600926
Thanks Rob. That's exactly what it was.
Regards
T
0

Featured Post

Secure Your Active Directory - April 20, 2017

Active Directory plays a critical role in your company’s IT infrastructure and keeping it secure in today’s hacker-infested world is a must.
Microsoft published 300+ pages of guidance, but who has the time, money, and resources to implement? Register now to find an easier way.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
Use Windows Task Scheduler to print a Word document weekly so your printer ink won't dry out.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

756 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question