LABEL.PROPERTIES

Macro Sheets Only

Equivalent to choosing the Object command from the Format menu when a label control is selected on a worksheet or dialog sheet. Sets the accelerator property of the label and group box controls.

Syntax

LABEL.PROPERTIES(accel_text, accel_text2, 3d_shading)
LABEL.PROPERTIES?(accel_text, accel_text2, 3d_shading)

Accel_text is a text string containing the character to use as the label's accelerator key on a dialog sheet. The character is matched against the text of the control, and the first matching character is underlined. When the user presses ALT+accel_text in Microsoft Excel for Windows or COMMAND+accel_text in Microsoft Excel for the Macintosh, the control is clicked. This argument is ignored for controls on worksheets.

Accel_text2 is a text string containing the second accelerator key on a dialog sheet. This argument is for only Far East versions of Microsoft Excel.

3d_shading is a logical value that specifies whether the list box appears as 3-D. If TRUE, the list box will appear as 3-D. If FALSE or omitted, the list box will not be 3-D. This argument is available for only worksheets.

Related Functions

CHECKBOX.PROPERTIES Sets various properties of check box and option box controls

SCROLLBAR.PROPERTIES Sets the properties of the scroll bar and spinner controls

PUSHBUTTON.PROPERTIES Sets the properties of the push button control

List of Customizing Functions