LABEL.PROPERTIES macro

Sets the accelerator property of the label and group box controls on a worksheet or dialog sheet.

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

Return to index