Adding a tip when the mouse is hovered over a shape in Excel....

[jbeard]

Hi

I have written several macros and attached them to various autoshapes
within my spreadsheet. Hence when one of these shapes is pressed the
macro runs.

What I want to try and do is to display a tip or help when the mouse is
hovered over the shape so that the user doesn't by accident select the
wrong shape if they are not familiar with the workbook.

Please can someone help.

Cheers,

JB

 

[Tim Williams]

Why not just put some text in the shape?

Tim

 

[jbeard]

I don't really want to clutter the layout with text and would therefore
rather keep with symbols.

The symbols are fairly obvious as to their meaning but I just want to
make sure.

Cheers.

 

[Tom Ogilvy]

Think you would have to utilize a control that has a mouseover event such as
any control from the control toolbox toolbar. You would then have to utilize
that event to display or hide a textbox with your message.

 

[Jimbo1]

Intsead of using a mouse over type macro could you just use a hyperlink
screen tip. Not ideal but a solution non the less.

 

[JOUIOUI]

Hi Tom,

I was searching through previous posts and came up with this one that fits
my situation. I have a very large spreadsheet that I want to put "UserTips"
in specific cells. I looked at the control toolbox toolbar and thought that
I could put my tips for each cell into a separate text box but have no idea
how to use VBA to display the text box when the mouse hovers over the cell.
Suppose I name the text box by the cell location, for example I have text
boxes named A1, B16, D45. Can you help me with how that code would look?

Thank you

 

[Dave Peterson]

I think that the closest you can do using excel is to insert a comment in that
cell.

You can also show a message via Data|Validation when the cell is selected.