Understanding Excel menu terminology

Vertex42 The Excel Nexus

Professional Excel Templates

Get Instant Access

Menu terminology is often a bit confusing at first because many of the terms are similar. The following list presents the official Excel menu terminology that I refer to in this chapter:

♦ Command bar: An object that can function as a menu bar, a shortcut menu, or a toolbar. It is represented by the CommandBar object in the Microsoft Office Object Library.

♦ Menu bar: The row of words that appears directly below the application's title bar. Excel has two menu bars: One is displayed when a worksheet is active, and the other is displayed when a chart sheet is active or when an embedded chart is activated.

♦ Menu: A single, top-level element of a menu bar. For example, both of Excel's menu bars have a File menu.

♦ Menu item: An element that appears in the drop-down list when you select a menu. For example, the first menu item under the File menu is New. Menu items also appear in submenus and shortcut menus.

♦ Separator bar: A horizontal line that appears between two menu items. The separator bar is used to group similar menu items.

♦ Submenu: A second-level menu that is under some menus. For example, the Edit menu has a submenu called Clear.

♦ Submenu item: A menu item that appears in the list when you select a submenu. For example, the Edit ^ Clear submenu contains the following submenu items: All, Formats, Contents, and Comments.

♦ Shortcut menu: The floating list of menu items that appears when you right-click a selection or an object. The shortcut menu that appears depends on the current context.

♦ Enabled: A menu or a menu item that can be used. If a menu or a menu item isn't enabled, its text appears grayed, and it can't be used.

♦ Checked: The status of a menu item that represents an on/off or True/False state. A menu item can display a graphical box that is checked or unchecked. The View ^ Status Bar menu item is an example.

♦ Image: A small, graphical icon that appears next to some menu items. In VBA terms, the code associated with each image is known as a FacelD. See Chapter 22 for more information about the FacelD property.

♦ Shortcut key combination: A keystroke combination that serves as an alternative method to execute a menu item. The shortcut key combination is displayed at the right side of the menu item. For example, Ctrl+S is the shortcut key combination for the File ^ Save command.

Was this article helpful?

0 0

Post a comment