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