Link to home
Start Free TrialLog in
Avatar of farrissf
farrissfFlag for United States of America

asked on

Tool tip for a shape...

I have a couple of shapes I created in my spreadsheet that I use like buttons to start a simple macro.  Is there a way to give the button a tool tip or something that behaves like one?  This is simple in PowerPoint but I can't figure it out in Excel 2007.
Avatar of top_rung
top_rung
Flag of United States of America image

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
ASKER CERTIFIED SOLUTION
Avatar of byundt
byundt
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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
Avatar of farrissf

ASKER

Simple but effective.