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?"
ASKER
Thanks, Teylyn, but I was trying to lean if there was a way to do it via VBA.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
You can change the shape and appearance of the comments box to suit your needs.
cheers, teylyn
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
That's very nice. How is it done?
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.
:)
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.
:)
Thanks.
ASKER
Thanks, Guys!
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