Select Constant Command (Edit Menu)

This page is specific to the Visual Basic for Applications (VBA) Language Reference for Office 2010.

Opens a dropdown list box in the Code window that contains the valid constants for a property that you typed, and that preceded the equal sign (=). The List Constants command also works for functions with arguments that are constants. To have the list box automatically open as you type your code, select Auto List Members on the Editor tab in the Options dialog box.

You can find the constant you want by:

  • Typing the name.

  • Using the up and down arrow keys to move up and down in the list.

  • Scrolling through the list and selecting the constant you want.

You can insert the constant into your code statement by:

  • Double-clicking the constant.

  • Selecting the constant and pressing TAB to insert the selection or pressing ENTER to insert the selection and move to the next line.

Toolbar shortcut: Gg278828.tbr_selc_ZA01201740(en-us,office.14).gif. Keyboard shortcut: CTRL+SHIFT+J.