Jun 202009

Form is the graphical container where other controls can be added to make user input logical and meaningful in Excel.

Here are the key controls

formcontro thumb Important Windows Control used to design Form in Excel VBA image

Label – To add label to the form

Textbox – To receive text input from user

ComboBox – Combination of Listbox and Textbox

ListBox – Let user pick an option from a list.

Checkbox – Receives input in check click

Optionbutton – Radio button input

ToggleButton – Let user enter Yes/No, True/False etc.

Frame – Can be used to make Optionbutton mutually exclusive

There are many more Controls. You can also add more controls to control toolbox. Each control is equipped with large number of properties to change look and feel of the control.

 June 20, 2009  , ,  Add comments

Leave a Reply