VBA Activex controls in Excel

In the previous chapter, we saw what controls are and what are Form controls.

In this chapter, we will see the second type of controls supported by Excel.

The VBA ActiveX controls are loaded separately in the Excel.

The VBA ActiveX controls are built in the Windows framework and is purely based on Microsoft technology.

The VBA ActiveX controls are Microsoft Windows specific and may not work with other OS.

For example, an Excel workbook built with ActiveX controls might not work with Mac OS.

because, these controls are loaded not by the Excel, but by the OS, in which case, it will not work with Mac.

But, VBA ActiveX controls provide far more flexibility and functionality when compared to Form controls.

To use VBA ActiveX controls:

Goto the Developer tab:

excel vba activex controls

Click Insert button in the Controls section:

excel vba activex controls

Drag and drop the control as needed.

Like form controls, ActiveX controls too have buttons, labels and so on, but apart from that, ActiveX controls will have other advanced controls too.

So, whenever a workbook is to be used within Windows OS, ActiveX controls will do good.


You can find similar Excel Questions and Answer hereunder

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

2) How do I restrict user entry in ActiveX Text Box to just numeric values?

3) Here an explanation about buttons in VBA

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

5) How to control forms in Excel VBA

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

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

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

9) In Excel we use forms to interface with the user. Here some basics about GUI or graphical user interface

10) How can I prevent users from seeing / accessing my macro code?


Here the previous and next chapter