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

Menuitems do not display tooltips in Excel unfortunately.

--
Jim
"ojv" <(E-Mail Removed)> wrote in message
news:95EF9F10-7B51-46AA-A479-(E-Mail Removed)...
| 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
|

Thx.

"Jim Rech" wrote:

> Menuitems do not display tooltips in Excel unfortunately.
>
> --
> Jim
> "ojv" <(E-Mail Removed)> wrote in message
> news:95EF9F10-7B51-46AA-A479-(E-Mail Removed)...
> | 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
> |
>
>