Visual Basic for Applications allows us to customize the menu system of the application dynamically by using the Menu object and the Menus Collection object. |
The Menubar object and its associated collection Menubars allows us to manipulate a specific menubar in the worksheet. Each new menu is contained in its parent menubar. Hence creating a menu involves adding it to a menubar. |
Different kinds of menus are the regular menus and the shortcut menus |