Control Toolbox Toolbar


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).


© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited TopPrevNext