ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   ToolTipText (https://www.excelbanter.com/excel-programming/332210-tooltiptext.html)

Glen Mettler[_4_]

ToolTipText
 
I have a multi-option menu bar. Everything works fine except the
ToolTipText.
Here is one of the options:

With .Add(msoControlButton)
.Caption = "Update Events"
.OnAction = "UpdateEvents"
.TooltipText = "Update Events from file - will
OVERWRITE"
End With
What I want is for the ToolTip to display when the user puts the mover over
the pulldown option.
How can I do that?

Glen



Jim Rech

ToolTipText
 
Menu items cannot display tool tips. Only toolbar buttons can. So you'd
have to add this control to a menu bar (a commandbar programmatically
speaking) rather than a menu.

--
Jim
"Glen Mettler" wrote in message
...
I have a multi-option menu bar. Everything works fine except the
ToolTipText.
Here is one of the options:

With .Add(msoControlButton)
.Caption = "Update Events"
.OnAction = "UpdateEvents"
.TooltipText = "Update Events from file - will
OVERWRITE"
End With
What I want is for the ToolTip to display when the user puts the mover
over the pulldown option.
How can I do that?

Glen





Damon Longworth

ToolTipText
 
You can accomplish this with the Caption property. Add the ampersand (&) to
the beginning of the caption:

.Caption = "&Your Mouse over message here"


"Glen Mettler" wrote in message
...
I have a multi-option menu bar. Everything works fine except the
ToolTipText.
Here is one of the options:

With .Add(msoControlButton)
.Caption = "Update Events"
.OnAction = "UpdateEvents"
.TooltipText = "Update Events from file - will
OVERWRITE"
End With
What I want is for the ToolTip to display when the user puts the mover
over the pulldown option.
How can I do that?

Glen






All times are GMT +1. The time now is 10:05 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com