Sets the properties of the push button control on a worksheet or dialog sheet.
Syntax
PUSHBUTTON.PROPERTIES(default_logical, cancel_logical, dismiss_logical, help_logical, accel_text, accel_text2)
PUSHBUTTON.PROPERTIES?(default_logical, cancel_logical, dismiss_logical, help_logical, accel_text, accel_text2)
Default_logical is a logical value that determines whether the button is the default button for the dialog. If TRUE, the button is the default button. If FALSE, the button is not the default button for the control.
Cancel_logical is a logical value that determines whether the button is activated when the dialog is cancelled with the Close button or the ESC key. If TRUE, the button is activated when the dialog box is cancelled, and edit boxes are not checked to see if they contain valid data types. If FALSE, the button is not activated when the dialog box is cancelled.
Dismiss_logical is a logical value that determines whether the button dismisses the dialog when pressed, as when the user presses the box's OK button. If TRUE, the button dismisses the dialog box. If FALSE, the button does not dismiss the dialog box.
Help_logical is a logical value that determines whether the button is activated when the user presses the F1 key. If TRUE, the button is activated when the user presses the F1 key. If FALSE, the button is not activated when the user presses the F1 key.
Accel_text is a text string containing the character to use as the dialog button's accelerator key. 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 push button 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.
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
EDITBOX.PROPERTIES Sets the properties of an edit box on a worksheet or dialog sheet
Return to index