Using controls on worksheets

Overview of the available controls

The table below shows which controls there are and describes each one shortly.

Pic.	Control name	Control use and remarks
	Label	Add a label next to other controls.
	Frame	Use this control to group other controls. OptionButtons placed within a frame work together.
	Button (CommandButton)	Start a macro
	CheckBox	Set an option, Select multiple options from a list of options.
	OptionButton	Select one option from a (short) list.
	ListBox	Select an option from a list. Multiple options are visible at the same time.
	ComboBox	Select an option from a list, only the selected option is visible.
	ScrollBar	Quickly change numeric values.
	Spinner	Change values step-by-step easily.
	TextBox	Enter a text.
	ToggleButton	Toggle status. This control is not recommended, I advise to use either a checkbox or a set of two OptionButtons.

Comments

Have a question, comment or suggestion? Then please use this form.

If your question is not directly related to this web page, but rather a more general "How do I do this" Excel question, then I advise you to ask your question here: www.eileenslounge.com.