Introduction

In this article we will be walking through how to add VBA Excel Buttons to improve your worksheets.

The VBA Excel Button

Button can make our lives easier by letting us choose certain text that we have in the list.

We have different types of buttons namely: Shapes Button, Form Control Buttons, ActiveX Control Buttons and Option Buttons.

Creating Macro Buttons using Shapes

We can have a stylish appearance by using a Shapes Button. We can customize is by choosing a shape, color, and font type.

Steps in using shapes as a button:

• You need to insert a shape in your worksheet.
• Go to insert tab then go to Illustration then Shapes drop-down then you can now choose a shape (in this case, we will choose rectangle).

• We can rename the shape into what kind of button we are going to create. Right-click on the button then click Edit text. You can also do it by double-clicking the shape.
• We can also rename the shape into what specific kind of button we will create.

We can rename the button in two different ways.

• hovering your cursor to the button and do right-click, then choose edit text then input the desired name.
• hovering your cursor to the button then double-click on the shape.

Assigning macros to the button

Steps to assign a macro:

• Right-click on the shape, then click assign macro.
• Rename the macro then choose This Workbook on the macros in dropdown then click Ok to save changes.

Creating Form Control Buttons

Shapes button and form control button have the same steps in setting-up. The difference between the two is the appearance of each button: the shapes button is stylish while form control button is a plain button. We can only change the font type, font-size, and font color.

Steps in creating a form control button:

• Go to developer's tab on your ribbon,
• Then choose insert.
• After clicking insert, a box will show then choose form controls.

This will create the form button and it will now show on our worksheet.

Creating ActiveX Controls Button

With ActiveX Controls, we have more options when formatting the button. We can now change the color of the ActiveX Controls button. We are required to add a macro code on it so we can run it in the active worksheet. The code will be inserted by going to view code.

This will give you the ActiveX control button or the command button.

Creating Option Button

The Option button as the name implies lets us choose from a variety of options.

We have the same steps when creating ActiveX button, and the steps are the following:

• Go to developers tab.
• Then click insert.
• Go to option button under ActiveX Control.
  ** the options button is located on the last row, the second option.

The above steps will give us the option button.

Conclusion

We have demonstrated several examples of creating different types of buttons including Shapes Button, Form Control Buttons, ActiveX Control Buttons and Option Buttons. We hope you can use all these buttons to make the most out of your Excel worksheets.