Rollover popup in Excel

I have a cell that, upon the user putting the cell over it, I'd like to show a "hint" for the cell.  For example, when I roll the cursor over cell A1, I want the popup to Read "this cell is for your home address?"
BBluAsked:
Who is Participating?
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Connect With a Mentor Microsoft MVP ExcelCommented:
Some examples of what comments can look like are attached.
comments.xlsx
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Hello,

right-click the cell and select Insert Comment.

Comments can be set to always show or be hidden. If they are hidden, they will pop up when the mouse rolls over the cell.

cheers, teylyn
0
 
BBluAuthor Commented:
Thanks, Teylyn, but I was trying to lean if there was a way to do it via VBA.
0
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
luconstaConnect With a Mentor Commented:
In VBA use .AddComment method:

Sub InsertComment()
    Range("A1").AddComment "Hello World!"
End Sub

Open in new window

0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
BBlu, not sure if you meant adding comments via VBA or creating the hover via VBA. If the latter, then expect a lot of work. Excel cells do not have a hover event. The out-of-the box comment does exactly what you describe: it displays a message when the mouse hovers over the cell. Why not use that?

You can change the shape and appearance of the comments box to suit your needs.

cheers, teylyn
0
 
Martin LissOlder than dirtCommented:
That's very nice. How is it done?
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
You can change the shape of the comment and when just the comment box is selected (not the content), the right click menu contains a format command with all the ususal suspects.

Changing the shape is a simple right-click away in 2003. In 2007 and later you need to add the (not in the ribbon) command "Change Shape" to the QAT.

:)
0
 
Martin LissOlder than dirtCommented:
Thanks.
0
 
BBluAuthor Commented:
Thanks, Guys!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.