EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Certification Courses
  • 120+ Courses All in One Bundle
  • Login
Home Excel Excel Resources Excel Tools Form Controls in Excel
Secondary Sidebar
Excel Functions
  • Excel Tools
    • Excel Shortcut Redo
    • Reduce Excel File Size
    • Quick Analysis in Excel
    • Goal Seek in Excel
    • Compare Two Lists in Excel
    • Excel Quick Analysis
    • Estimate Template in Excel
    • Pivot Table Count Unique
    • CSV Files into Excel
    • Excel Business Plan Template
    • Excel Export to PDF
    • Free Excel Template
    • Excel Repair
    • Color in Excel
    • Form Controls in Excel
    • Timecard Template in Excel
    • How to Unhide All Sheets in Excel?
    • Power Query in Excel
    • Power View in Excel
    • XML in Excel
    • Excel Evaluate Formula
    • Examples of Excel Macros
    • Consolidation in Excel
    • Ribbon in Excel
    • Excel Conditional Formatting for Dates
    • Protect Sheet in Excel
    • Data Model in Excel
    • Pivot Table Examples
    • Pivot Table Slicer
    • Pivot Table Filter
    • Watch Window in Excel
    • Slicer in Excel
    • Print Gridlines in Excel
    • Convert Numbers to Text in Excel
    • Freeze Columns in Excel
    • Spelling Check in Excel
    • Name Box in Excel
    • Solve Equation in Excel
    • Excel Spreadsheet Examples
    • What If Analysis in Excel
    • How to Print Labels From Excel
    • Excel Named Range
    • Excel TRANSPOSE Formula
    • Excel Merge and Center
    • Excel Freeze Rows
    • HLOOKUP Formula in Excel
    • Excel Create Database
    • Excel Gridlines
    • Excel Spreadsheet Formulas
    • Excel Sort By Number
    • Excel Concatenating Columns
    • Excel AutoCorrect
    • Conditional Formatting For Blank Cells
    • Excel Icon Sets
    • Excel CTRL D
    • Excel Accounting Number Format
    • Excel Regression Analysis
    • Excel Import Data
    • Excel Freeze Panes
    • Excel Calendar
    • Excel Developer Tab
    • Excel Enable Macros
    • Excel Autosave
    • Heat Map in Excel
    • Excel Toolbar
    • Excel Error Bar
    • Excel Status Bar
    • Excel Unprotect Sheet
    • Check mark in Excel
    • Excel Column Filter
    • Excel Header and Footer
    • Excel Drawing
    • Range in Excel
    • Timeline in Excel
    • Excel Lock Formula
    • Excel Table styles
    • Insert New Worksheet in Excel
    • Excel Column Lock
    • Excel Forms for Data Entry
    • QUOTIENT in Excel
    • Excel Sorting
    • Excel Sort by color
    • Excel Data Bars
    • Excel Tool for Data Analysis
    • Excel Flash Fill
    • Excel Auto Fill
    • Excel Quick Access Toolbar
    • Excel Wrap Text
    • Excel Exponential Smoothing
    • Excel ANOVA
    • Excel Merge Two Tables
    • Excel Conditional Formatting in Pivot Table
    • Dynamic Tables in Excel
    • Excel Sort by date
    • Excel Dynamic Range
    • Record Macro in Excel
    • Two Variable Data Table in Excel
    • Merge Cells in Excel
    • One Variable Data Table in Excel
    • Excel Fill Handle
    • CheckBox in Excel
    • Excel Table
    • Excel Combo Box
    • Auto Format in Excel
    • Advanced Filter in Excel
    • Excel AutoFilter
    • Excel Data Filter
    • Excel Data Validation
    • Excel Radio Button
    • Data Table in Excel
    • Text to Columns in Excel
    • Excel List box
    • Excel Solver Tool
    • Scrollbar in Excel
  • Excel Functions (12+)
  • Financial Functions in Excel (17+)
  • Logical Functions in Excel (14+)
  • Lookup Reference Functions in Excel (35+)
  • Maths Function in Excel (47+)
  • TEXT and String Functions in Excel (26+)
  • Date and Time Function in Excel (24+)
  • Statistical Functions in Excel (59+)
  • Information Functions in Excel (4+)
  • Excel Charts (56+)
  • Excel Tips (222+)
  • Workplace Productivity (4+)
  • Microsoft Office Tools (15+)
  • Excel Formula and Functions (22+)
  • MS Excel Shortcuts (4+)
Excel Functions Courses
  • EXCEL ADVANCED Training
  • EXCEL Training COURSE

Form Controls in Excel

By Ashwani JaiswalAshwani Jaiswal

Form Controls in Excel

Excel Form Controls (Table of Contents)

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

Introduction to Form Controls in Excel

Form Controls objects are used for creating buttons, boxes, list bar, 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. In Form Controls, we have Buttons, Combo box, CheckBox, Spin Button, List Box, Option Box, Group Box, Scroll Bar, Text Field, Combo List-Edit, Combo Drop Down-Edit, respectively. Below we have the screenshot.

Start Your Free Excel Course

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

How to Use Form Control in Excel?

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

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 were; just by scrolling, checking the boxes, we would get some values output.

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

Example #1

We will see all the objects in Form Control one by one in this example. 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.

All in One Excel VBA Bundle(120+ Courses, 30+ Projects)
Basic ExcelAdvanced ExcelVBA & MacrosExcel Dashboards
Pivot TablesStatistical FunctionsFinancial FunctionsCharts & Graphs
Price
View Courses
120+ Online Courses | 30+ Projects | 500+ Hours | Verifiable Certificates | Lifetime Access
4.9 (64,412 ratings)

Form Controls in Excel - Button 1

We can edit the name of the button 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 in 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, 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

Just by a single click on it, we will see a Tick inside the box.

Checkbox -Tick Mark

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

Format Object

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

Checkbox -Forms 1

4. Spin Button – As the name says, we can spinning 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 cell link as well.

Format Controls-Spin Button 1

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

Spin Button - form

5. List Box – List Box can contain any range of list values. Select the option and draw anywhere in 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

We will see, in the List box, all the numbers from the input range are seen. We can navigate to 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 select cell A2.

Object button 1

Now, 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 Radio control which is customized.

8. Label – Label works just as a simple sticker. Its main purpose is to show the value or text entered in it, 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 how it looks like below.

Scroll Bar 1

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

Format Control -Scroll

By clicking on the up and down arrow, we will see the change in cell A3, which is 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 any form of 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

  • The second part of the Insert option, which is ActiveX, is only used for macros.
  • Form Controls are used for both manual data and macros.
  • Text Field, Combo List-Edit, and Combo Drop Down-Edit are customized form controls.
  • Form Controls can also be used with charts.

Recommended Articles

This is a guide to Form Controls in Excel. Here we discuss how to use Form Controls in Excel and 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?
Popular Course in this category
Excel Advanced Training (16 Courses, 23+ Projects)
  16 Online Courses |  23 Hands-on Projects |  140+ Hours |  Verifiable Certificate of Completion
4.8
Price

View Course

Related Courses

Excel Training (23 Courses, 9+ Projects)4.9
0 Shares
Share
Tweet
Share
Primary Sidebar
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Corporate Training
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Excel Charts
  • Excel Tips
  • All Tutorials
Certification Courses
  • All Courses
  • Excel VBA Course - All in One Bundle
  • VBA Course
  • Excel Data Analysis Course
  • Excel for Marketing Course
  • Excel for Finance Course
  • Excel for HR Training

ISO 10004:2018 & ISO 9001:2015 Certified

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

EDUCBA
Free Excel Course

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

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

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA
Free Excel Course

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

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

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

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

By signing up, you agree to our Terms of Use and Privacy Policy.

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

Download Form Controls Excel Template

EDUCBA

Download Form Controls Excel Template

EDUCBA

डाउनलोड Form Controls Excel Template

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more