Tool tip for a shape...

I wasn't sure how this was done other than by using a hyperlink (in which case you simply at the tooltip to the hyperlink properties), and so I searched around.. I found this topic on a forum and the first uses a hyperlink as I was thinking...
I hope this is helpful!

http://tinyurl.com/5v6e8w
In case the link is every broken, here are the contents.......

"
Do not assign the macro directly to the Shape. Instead, assign a hyperlink
to the Shape to take you to a remote location within the worksheet, say Z100.
Then create a worksheet event macro to call the desired macro whenever z100
is Selected.

The advantage to using the hyperlink is that you can assign a tooltip to the
hyperlink that will appear by mouse_over. Here is an example:

Say the macro you want to run is named dural. In worksheet code enter:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Set t = Target
Set r = Range("Z100")
If Intersect(t, r) Is Nothing Then Exit Sub
Call dural
End Sub
"

Or----------


"
Look up ControlTipsText in VBA help file. Here is some sample code from the
help file.

Private Sub UserForm_Initialize()
MultiPage1.Page1.ControlTipText = "Here in page 1"
MultiPage1.Page2.ControlTipText = "Now in page 2"

CommandButton1.ControlTipText = "And now here's"
CommandButton2.ControlTipText = "a tip from"
CommandButton3.ControlTipText = "your controls!"
End Sub
"

Shapes do not support tool tips. If your shape invoked a hyperlink then you can use the screen tip text of the hyperlink function but, if you are invoking a macro there is no tool tip function.

Kevin

There is some code here that imitates tooltips for an image control - it ought to work with other shapes I think: http://www.vbaexpress.com/forum/showthread.php?t=15084&highlight=tooltip
Regards,
Rory

Simple but effective.