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.

alt text

alt textDesign Mode - Switches to forms design mode, where you can edit or create a form by using the ActiveX tools on the Control Toolbox.
alt textProperties - Displays the properties window allowing you to change the properties of the control.
alt textView Code - Displays the Visual Basic Editor.
alt textCheck Box - Allows the user to either select or deselect an option.
alt textText Box - Allows you to display text and to allow the user to enter information.
alt textCommand Button - Allows the user to perform a specific action by running a subroutine.
alt textOption Button - Allows the user to select from a list of possible choices. These are normally placed inside frames.
alt textList Box - Allows the user to select from a list of possible choices.
alt textCombo 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.
alt textToggle Button - Allows the user to toggle between two states.
alt textSpin Button - Allows the user to select a value by clicking on two buttons either to increase or decrease its value.
alt textScroll Bar - Allows the user to drag a button to change a value.
alt textLabel - Allows you to display text to the user.
alt textImage - Allows you to display a graphic or picture.
alt textMore 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).


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