CommandButton is used to run or execute a macro or procedure.

It performs a task or an action when a user clicks on a command button.

Please find more details about ActiveX CommandButton Control in the following chapter.

You can see how we are adding or deleting command button on the UserForm or Worksheet.

In the below example, its deleting the command button named New Button which is on the UserForm named UserForm4.

We can use Remove method to delete the controls which are created during run time.

Controls which are created during design time cannot be deleted using this method.

Please find the below example and screen shots for better understand.

And make this place as the best source for all business analysts to learn share data analysis concepts and its relevant tools for creating innovative dashboards awesome tools for analyzing the data.

Your job, if you choose to accept it, is to add some controls to this UserForm.

You use the tools in the Toolbox to add controls to your UserForm.

If, for some reason, the Toolbox doesnt appear when you activate your UserForm, choose View Toolbox.

After you add a control, you can move and resize it by using standard techniques.

In addition, the UserForm itself has its own set of properties.

You can change these properties with the aptly named Properties window.

This shows the Properties window when a CommandButton control is selected.

If you select a different control, the properties change to those appropriate for that control.

To hide the Properties window and get it out of the way, click the Close button in its title bar.

To change a property using the Properties window, follow these steps.

If youre viewing code, double-click the UserForm name in the Project window to return to the UserForm.

Most of the time, you wont have any more code in the procedure.

As you later see, you put your event-handler procedures in the Code window for the UserForm.

For example, if you add a CheckBox control to a UserForm named UserForm1, the CheckBox control is named CheckBox1 by default.

You can use the Properties box to make this control appear with a check mark.

If thats the case, you can omit the UserForm object qualifier and write the statement like this.

The following statement executes a macro named PrintReport if the check box (named CheckBox1) is checked.

He has been named a Microsoft MVP for his ongoing contributions to the Excel community.

Create Userform In Excel For Mac