Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 102
Default Tool tip for controls

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.
  #2   Report Post  
Posted to microsoft.public.excel.programming
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.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
using gui controls daddy260 Excel Discussion (Misc queries) 4 May 25th 07 07:35 AM
HTML Controls michael sharpe Excel Discussion (Misc queries) 0 September 6th 06 08:14 PM
ActiveX Controls vs Form Controls Alex Excel Discussion (Misc queries) 1 January 11th 06 08:46 AM
I am missing view tool bar from tool menu. excel New Users to Excel 1 July 4th 05 07:19 PM
Controls on worksheet gr8guy Excel Programming 1 May 1st 04 03:11 AM


All times are GMT +1. The time now is 11:40 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"