The Microsoft Office Excel Control Toolbox has many controls and this tutorial describes what each control does and how you can use them.
1. Open Microsoft Excel
For this tutorial, you can use a pre-existing Excel file but I always like to create a new file so I don’t end up making undesired changes to the currently existing file, so open Microsoft Excel to create a new file.
2. Click View – Toolbars – Control Toolbox
This will bring up the Excel Control Toolbox with different buttons for each control. Below is a list of each control with a brief description. (Note to make changes to any control, either click on “Properties” or right-click the control and click Object – gt; Edit). To use the buttons, click on one of the control buttons and then click anywhere on the worksheet to place the control on the worksheet.
Design Mode: Lets you make changes to any control on the worksheet. When you are in design mode, you have the ability to make modifications to all the controls on the sheet.
Properties: You can set the individual properties (like height, color, width, font, etc) for all the controls currently on the worksheet. From the dropdown of the properties window, you can select which control you want to change, and below you can make the changes to the different available properties.
- View Code: This is an advanced feature that you can use with macros.
- Check Box: You can create a standard checkbox.
- Text Box: Create a standard textbox.
- Command Button: Create a clickable button.
- Option Button: Create a standard radio button.
- List Box: Create a standard list box.
- Combo Box: Create a standard combo box / drop-down menu.
- Toggle Button: Create a standard toggle button with on/off type functionality.
- Spin Button: Create a standard spin button to increment/decrement quantities.
- Scroll Bar: Create a standard scroll bar to move up/down.
- Label: Create a standard label with static text.
- Image: Create a standard image to include pictures.
- More Controls: Depending on what you have installed on your machine, you will see hundreds of additional controls you can include in your workbook!
Most of these controls from the Excel Control Toolbox are pretty self-explanatory, and in order to understand how to correctly use them requires actual hands-on practice. I would suggest keeping your Control Toolbox docked at the top with the other toolbars so you can easily access any of the controls when you need to.
You can use the controls from the Control Toolbox listed above to make your Excel worksheet more interactive and user-friendly. You can also provide additional functionality by adding control to your worksheets.