View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Kilmer Bob Kilmer is offline
external usenet poster
 
Posts: 280
Default Tool tip for controls

Crude, perhaps, but a suggestion: I have been able to show and hide a
userform or a label or other control using the MouseMove events of a button
and a label on a worksheet. I place and size one label so that the label
just surrounds the button placed upon it. If I use a label to display the
tool tip, I place a second label to serve as the tooltip window. The button
MouseMove event shows the "tooltip" and the surrounding label MouseMove
event hides the "tooltip." Additional logic and perhaps a timer could be
used to further refine the timing of the display of the tooltip control or
dialog.

If this is too clunky, can you use the Excel status bar or a central label
control to display useful tips for the user, tiggered by GotFocus or
MouseMove events on controls?

"Mark" wrote in message
om...
Does anyone know if there is a way to supply a tool tip for an excel
control on a worksheet. The option is not available as it is in a
Visual Basic control. Any workarounds or suggestions would be
appreciated. Thanks for your time.
Mark

P.S. I am not experienced with windows handles so if you suggest
something along those lines, it will have to be detailed.