farrissf
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.
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
Kevin
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
Regards,
Rory
ASKER
Simple but effective.
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(
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.ControlTi
MultiPage1.Page2.ControlTi
CommandButton1.ControlTipT
CommandButton2.ControlTipT
CommandButton3.ControlTipT
End Sub
"