Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Button tips
Using Basic Shapes as buttons running macros, is it possible for a
descriptive 'tip' to be programmed in which will appear when the mouse hovers over, as is the case with toolbar buttons? Francis Hookham |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Button tips
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 -- Gary''s Student - gsnu2007g "Francis Hookham" wrote: Using Basic Shapes as buttons running macros, is it possible for a descriptive 'tip' to be programmed in which will appear when the mouse hovers over, as is the case with toolbar buttons? Francis Hookham |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Button tips
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 "Francis Hookham" wrote: Using Basic Shapes as buttons running macros, is it possible for a descriptive 'tip' to be programmed in which will appear when the mouse hovers over, as is the case with toolbar buttons? Francis Hookham |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Button tips
Thank you JLGWhiz and Gary''s Student for your wonderful prompt reply.
I'll try both I am most grateful Francis |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vba tips and help | Excel Programming | |||
Screen Tips | Excel Discussion (Misc queries) | |||
Tool tips or screen tips | Excel Programming | |||
need some tips! | Excel Worksheet Functions | |||
Tips and Tricks | Excel Discussion (Misc queries) |