EDUCBA Logo

EDUCBA

MENUMENU
  • Explore
    • EDUCBA Pro
    • PRO Bundles
    • Featured Skills
    • New & Trending
    • Fresh Entries
    • Finance
    • Data Science
    • Programming and Dev
    • Excel
    • Marketing
    • HR
    • PDP
    • VFX and Design
    • Project Management
    • Exam Prep
    • All Courses
  • Blog
  • Enterprise
  • Free Courses
  • Log in
  • Sign Up
Home Excel Excel Resources Excel Tools Form Controls in Excel
 

Form Controls in Excel

Ashwani Jaiswal
Article byAshwani Jaiswal
Madhuri Thakur
Reviewed byMadhuri Thakur

Updated May 29, 2023

Form Controls in Excel

 

 

Excel Form Controls (Table of Contents)

Watch our Demo Courses and Videos

Valuation, Hadoop, Excel, Mobile Apps, Web Development & many more.

  • Introduction to Form Controls in Excel
  • How to Use Form Control in Excel?

Introduction to Form Controls in Excel

Form Controls objects create buttons, boxes, list bars, and scrolls. Form controls can be accessed from the Developer menu tab with two types of sections in it. The first is Form Controls, and the other is ActiveX Controls. Here we will only be seeing Form Controls in detail. Form Controls has Buttons, Combo boxes, CheckBox, Spin buttons, List boxes, Option Boxes, Group Boxes, Scroll bars, Text fields, Combo List-Edit, and Combo Drop Down-Edit, respectively. Below we have the screenshot.

How to Use Form Control in Excel?

Use Form Control and Go to the Developer menu tab (If activated from the File menu option). We can find Form Control under the Control section, as shown in the screenshot below.

Forms Control in excel 1-1

Form Controls in Excel allow us to create different types of controls by just selecting and dragging them anywhere in the worksheet. The work doesn’t end here; we will need to connect the inserted Form Controls with the data, where we would get some values output by scrolling and checking the boxes.

You can download this Form Controls Excel Template here – Form Controls Excel Template

Example #1

In this example, we will see all the objects in Form Control one by one. For this, you just simply need to select the Form Control boxes from the menu option and drag and draw to get the button shape object.

1. Buttons – Once we select and draw this button, we will immediately get a dialog box of Assign Macro. Now there, edit and give a name to Macro Name. Here we have kept it as Button.

Form Controls in Excel -Button

We will then get a button in the area where it is drawn.

Form Controls in Excel - Button 1

We can edit the button’s name as well, just by putting the cursor on it.

Form Controls in Excel - Button 1-1

To assign a macro to this button, right-click and select Assign Macro.

Form Controls in Excel - Button 1-3

2. Combo box – To use Combo Box, select the option and draw anywhere on the sheet.

Form Controls in Excel - Combobox 1

To assign value to the Combo Box drop-down, click right on it and select Format Control.

Form Controls in Excel - Combobox 2

Select the range of input cells. Here it is from A1:A5 with drop down lines as 5.

Form Controls in Excel - Combobox 3

Once done, click on the drop-down arrow, and we will be able to see all the selected values. And we can select any value as well.

Form Controls in Excel - Combobox 4

3. CheckBox – This is used when we just need to mark an option for status. Please select this option from Form Control and draw it.

Checkbox-Forms Controls

We will see a Tick inside the box just by a single click on it.

Checkbox -Tick Mark

Right-click on the box and select Format Controls. Select the type and cell link as shown below.

Format Object

When we check the CheckBox with a tick mark, we get TRUE at the selected cell. And FALSE when unchecked.

Checkbox -Forms 1

4. Spin Button – As the name says, we can spin around the selected values by this. Select and draw this on the worksheet.

Spin Button 1

Right-click and select Format Control.

Format Controls-Spin Button

Now under the Control tab, give the limit as per requirement and select the cell link.

Format Controls-Spin Button 1

We can then click on the Up and Down arrow to navigate the values from 1 to 12.

Spin Button - form

5. List Box – A list Box can contain any range of list values. Select the option and draw anywhere on the sheet.

List Box 1

Right-click on any List menu and select Format Control. Then in the window of Format Control, select the Input range and Cell link. Here we have selected the range input range of numbers 1 to 5.

Format Object - List Box

In the List box, we will see all the numbers from the input range. We can navigate up and down and select and number. And the number will be seen in Cell Link B1.

Forms Controls

6. Option Button – This is used when we need to select one option among others. Select and draw this anywhere in the worksheet.

Option box 1

Right-click on this and select Format Object. Now in the window below, select the Cell Link. We have selected cell A2.

Object button 1

If we select this option box, reference cell A2 will be seen with a value of 1. And unchecking it will show 0.

Option Button

7. Group Box – This is used for multi controls. This only allows us to group other controls under it. Select and draw in a worksheet.

group box

Right-click on it and select Format Control, as shown below.

Format Control-Group Box

To group different controls here, we first need to have a customized Radio control.

8. Label – The label works just as a simple sticker. Its main purpose is to show the value or text entered, as shown below.

Test Control

9. Scroll Bar – With this, we can navigate the window up and down as we did in the List button. This is what it looks like below.

Scroll Bar 1

Right-click and select Format Object. From there, select the minimum and maximum value and cell link.

Format Control -Scroll

By clicking the up and down arrow, we will see the change in cell A3, our cell link.

scroll bar

The rest of the Controls are not activated. All those left controls are customized.

Pros of Form Controls

  • All the mentioned controls are easy to implement. And we all have seen some of them in our work.
  • The format Control option is the same for most of the control. So it becomes easy to select the range and cell link.

Things to Remember

  • Only use the ActiveX option for macros in the second part of the Insert menu.
  • Use the Form Controls for both manual data and macros.
  • Text Field, Combo List-Edit, and Combo Drop Down-Edit are customized form controls.
  • You can also use Form Controls with charts.

Recommended Articles

This is a guide to Form Controls in Excel. Here we discuss how to use Form Controls in Excel, practical examples, and a downloadable Excel template. You can also go through our other suggested articles –

  1. Sentence Case in Excel
  2. Excel Combo Box
  3. Examples of Excel Macros
  4. How to Edit Drop Down List in Excel?

Primary Sidebar

Footer

Follow us!
  • EDUCBA FacebookEDUCBA TwitterEDUCBA LinkedINEDUCBA Instagram
  • EDUCBA YoutubeEDUCBA CourseraEDUCBA Udemy
APPS
EDUCBA Android AppEDUCBA iOS App
Blog
  • Blog
  • Free Tutorials
  • About us
  • Contact us
  • Log in
Courses
  • Enterprise Solutions
  • Free Courses
  • Explore Programs
  • All Courses
  • All in One Bundles
  • Sign up
Email
  • [email protected]

ISO 10004:2018 & ISO 9001:2015 Certified

© 2025 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.
*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

EDUCBA

Download Form Controls Excel Template

EDUCBA Login

Forgot Password?

EDUCBA

Download Form Controls Excel Template

EDUCBA

डाउनलोड Form Controls Excel Template

🚀 Limited Time Offer! - 🎁 ENROLL NOW