Question

What is a form control in Excel, provide an example.

Answer 1

Excel Form Controls are objects which can be inserted at any place in the worksheet to work with data and handle the data as specified.

We can create a drop-down list, list boxes, spinners, checkboxes, scroll bars using form control.
In excel “Form Control” is available under the “Developer” tab.

Source File Home Insert Page Layou Formulas Data Review View Developer Help | Properties - View Code Visual Macros Add- Excel COM Insert Design Basic ins Add-ins Add-ins Mode E! Run Dialog Code Add-ins Form Controls K11 : X foc OVO 28 O 1 Aa 8 abl 1 A B C D G H ActiveX Controls 1 58 abl O AD Y

The below image describes all the “Form Controls in excel ” in detail.

Spin Button Check Box L List Box Monday Tuesday Combo Box Button FormAContfols +-----GIÀÉEO--- 03 A 8 ab 1 3 Option Button r Group Box Scroll Bar Label

Example:- Using Combo box

Combo Box is simply our drop-down list.
Step 1:- Select the “Combo Box” from the form control, anywhere on the worksheet area.

A B C D E -nm +

Step 2:- Now to insert values create day list in column A.

A B C D E Day 1 2 Monday Tuesday Wednesday Thursday Friday Saturday Sunday

Step 3:- Now select the “Combo Box” then right click and choose “Format Control”.

Grouping Order Assign Macro... Format Control...

Step 4:- Now in the “Format Control” window choose “Control”. In the “Input Range” choose month names range of cells (i.e, from A2 to A8). Click Ok.

Format Object ? X Size Protection Properties Alt Text Control 1 2 3 4 A Day Monday Tuesday Wednesday Thursday Friday Saturday Sunday. Input range: $A$2:$A$8 Cell link: Drop down lines: 8 6 3-D shading 8 12 OK Cancel

Step 5:- Now you will see the selected day list in the combo box.

B C D E 2 3 4 5 6 7 8 9 A Day Monday Tuesday Wednesday Thursday Friday Saturday Sunday Monday Tuesday Wednesday Thursday Friday Saturday Sunday