Help: class members drop menu popup control vba

Drop Menu Popup Object

Popup Menu Item Class Members

Popup menu item is a menu item with text and optional image, which shows next level of menu when selected.

Ribbon Drop Button

In the example above Currency Settings is a popup menu.


AddCommand

Adds new Command Item to this menu.

AddPopup

Adds new Popup Menu as a subitem to this menu.

AddSeparator

Adds new Separator to this menu.

Caption

Text shown on this menu item.

Count

Count of items in this popup menu.

Enabled

State of the item. It item is disabled it can't be selected and shown as grayed.

Image

Image shown on this item. This property is optional. Item can contain text only.

Item( 1-based index )
Item( tag )

Return subitem object by index or tag.

Tag

Internal name of this item. You can refer to this item using Tag.

Visible

If this property is set to false, item is hidden.


Visual Basic Code below adds new Popup menu to the parent menu.

With .Menu
 With .AddPopup
  .Caption = "Currency Settings ..."
  .Image = "Options"
  With .AddCommand
   .Caption = "Enable\Disable EURO"
   .Image = "Pencil"
   .Tag = BTN_ENABLE_EURO
   .OnAction = "OnEnableEuroCurrency"
  End With
 End With 
End With