View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ojv[_2_] ojv[_2_] is offline
external usenet poster
 
Posts: 53
Default 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