CommandBarControls.Add([Type], [Id], [Parameter], [Before], [Temporary]) where the parameters are: Type The type of menu. Valid constants are msoControlButton, msoControlEdit, msoControlDropdown, msoControlComboBox, and msoControlPopup. Id The menu item's identifier. For a custom item, this should be left or or set to 1. Parameter Passes arguments to the procedure that the menu item invokes. Before Position before which the new menu item should appear. Temporary If True, deletes the menu item when Excel is closed.