Vba form controls in Excel

Controls are elements that make up a user interface.

They give visual structure to the user interface. Controls are generally held inside the form,

though, Excel allows inserting controls in the worksheet, too.

In this chapter, we will see the first type of controls called, Form controls

Form controls are one that are built into Excel.

They have their definition within the excel and hence can be deployed to any other OS.

For example, A worksheet containing form controls, developed in Windows can be used with Mac OS.

Since, the controls are native to the Excel.

Form controls are simple and are most often used controls in Excel.

The controls we have used in this workbook are form controls.

The following figure illustrates this:

Go to Developer tab:

excel vba form controls

In the Controls section, click the Insert icon.

excel vba form controls

Here, it shows two sets of controls, Form controls and ActiveX controls.

Any form control can be used by just dragging and dropping in the desired position in the worksheet.

The various types of form controls are Button,Label,Textbox,ComboBox,Dropdown list and so on.


You can find similar Excel Questions and Answer hereunder

1) What are ActiveX controls in VBA. Here some good explanations

2) I have data arranged in rows of information. Is there any way I can enter new data through a form instead of entering it directly in SpreadSheet?

3) Here an explanation about frames and how to control frames in Excel VBA

4) Here an explanation about combo boxes and interfacing with your user in Excel VBA

5) Here an explanation about spin button and how to control it using VBA

6) Here an explanation about text box and how to control text boxes in Excel VBA

7) Here an explanation about list box and how to control list boxes in Excel VBA

8) Here an explanation about checkbox and how to control checkboxes in Excel VBA

9) Here some explanations about the events related to the forms and how to control them

10) I have a WorkBook that loads a form automatically when it is opened. In Excel, how can I suppress the form from loading on file open when required?


Here the previous and next chapter