Commanndbar and tooltip display

O

ojv

Use code as below to add controls to a menu item. Even though I set the
ToolTipText parameter to some value it is not displayed in the menu i make.
What am I missing? Any help appreciated.

Dim NewMenu As CommandBarPopup
Dim MenuItem As CommandBarControl
Set MenuItem = NewMenu.Controls.add(Type:=msoControlPopup)
With MenuItem
.Caption = "&Data"
.BeginGroup = True
.TooltipText = "Import result data to worksheets in new workbook," &
vbCrLf & _ "create new tags or compress data."
End With
 
J

Jim Rech

Menuitems do not display tooltips in Excel unfortunately.

--
Jim
| Use code as below to add controls to a menu item. Even though I set the
| ToolTipText parameter to some value it is not displayed in the menu i
make.
| What am I missing? Any help appreciated.
|
| Dim NewMenu As CommandBarPopup
| Dim MenuItem As CommandBarControl
| Set MenuItem = NewMenu.Controls.add(Type:=msoControlPopup)
| With MenuItem
| .Caption = "&Data"
| .BeginGroup = True
| .TooltipText = "Import result data to worksheets in new workbook," &
| vbCrLf & _ "create new tags or compress data."
| End With
|
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using Excel 2007 with Excel 2003 template 1
Nested Sub Menus 3
MenuItem Check Mark 1
menu bar & chart menu bar 10
Creating a toolbar for my add-in 4
Add-In - OnAction Can't Find Macro & Subs Doesn't Affect Current Wkb 6
NewMenu 5
CommandBars vs CommandBars(1).Controls 3

Top