Commanndbar and tooltip display
 

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

Commanndbar and tooltip display
 

Menuitems do not display tooltips in Excel unfortunately.

--
Jim
"ojv" wrote in message
...
| 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
|

Commanndbar and tooltip display
 

Thx.

"Jim Rech" wrote:

Menuitems do not display tooltips in Excel unfortunately.

--
Jim
"ojv" wrote in message
...
| 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
|