Control Toolbox Toolbar
Removed in 2007
Understand the Controls
These controls are all ActiveX controls and will require you to add some VBA code to the necessary events.
![]() |
![]() | Design Mode - Switches to forms design mode, where you can edit or create a form by using the ActiveX tools on the Control Toolbox. |
![]() | Properties - Displays the properties window allowing you to change the properties of the control. |
![]() | View Code - Displays the Visual Basic Editor. |
![]() | Check Box - Allows the user to either select or deselect an option. |
![]() | Text Box - Allows you to display text and to allow the user to enter information. |
![]() | Command Button - Allows the user to perform a specific action by running a subroutine. |
![]() | Option Button - Allows the user to select from a list of possible choices. These are normally placed inside frames. |
![]() | List Box - Allows the user to select from a list of possible choices. |
![]() | Combo Box - Allows the user to either select an item from the drop-down list or to enter a different value into the text box at the top. |
![]() | Toggle Button - Allows the user to toggle between two states. |
![]() | Spin Button - Allows the user to select a value by clicking on two buttons either to increase or decrease its value. |
![]() | Scroll Bar - Allows the user to drag a button to change a value. |
![]() | Label - Allows you to display text to the user. |
![]() | Image - Allows you to display a graphic or picture. |
![]() | More Controls - Lets you add additional controls to your document. |
Important
The following controls cannot be added to a worksheet, Tab Control, Multi Page, RefEdit.
You can size controls automatically to fit cells by holding down the Alt key as you adjust the size.
You cannot add these controls to a Chart Sheet.
When you add a control to a worksheet it actually sits in the drawing layer (as opposed to the Value or Formula layer).
© 2023 Better Solutions Limited. All Rights Reserved. © 2023 Better Solutions Limited TopPrevNext