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.|
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).
© 2020 Better Solutions Limited. All Rights Reserved. © 2020 Better Solutions Limited TopPrevNext