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
|