How to insert and configure ActiveX controls on a worksheet in Excel

Who I am
Marie-Ange Demory
Author and references

ActiveX controls are often confused with form controls but there are notable differences between them. And these ActiveX controls have certain features that can be configured. Among the most popular controls we can find are the control of program , Windows Media Player, etc.

We need to be especially careful to know that some of these ActiveX controls cannot be used directly from a spreadsheet. And if you try to insert it into a spreadsheet, the message "Failed to insert subject" will appear. But in general, insert and configure ActiveX controls in Excel it's very simple.

How to insert and configure ActiveX controls on a worksheet in Excel

In a previous article we were able to show you and we will teach you how easy it is to use the numerical control ActiveX in an Excel spreadsheet. These tutorials have a pedagogical orientation, to help you learn a little more about the uses of the different functions of this program.

In the following article we will teach you in a very simple way how insert and configure ActiveX controls in an Excel spreadsheet. To perform this action we will go to our spreadsheet and in it we will position ourselves in the main menu. This is the one above and in it we will select the Developer tab.

When you perform this action, some options will appear from which you will select the group of controls options and in it you will click Insert. Now go to the ActiveX control box and in it you will choose a control. If you can't find what you need, you can click on the More Controls option, this way you can see all available controls.

Once you have found the ActiveX control and selected it, you need to click on the area or area of ​​the spreadsheet where you want the control to appear. In order to make changes to the control, you need to make sure it is in Design mode. You will find it in the tab Developer, Control group and then Design mode.

Configuring ActiveX Controls on a Worksheet in Excel

So that you can specify the properties ActiveX control, you also need to go to the Programmer tab, then in Control Group you need to create a clip in Properties. When you do, the dialog box will appear. And you will see each property, if you want to know information about each of them you have to select it and then press F1 key.

This action will show you the Visual Basic help topics, you can also type in the search box the name of some properties and then press the Enter key. This way you can configure ActiveX controls and give them the quality you want. This is a very simple and easy way to insert and configure ActiveX controls in an Excel spreadsheet.

This way we have instructed you with another feature of the versatile desktop application called Microsoft Exel. This time we wanted to expand the knowledge of ActiveX controls a little more. So that you learn a insert and configure them in a spreadsheet.

add a comment of How to insert and configure ActiveX controls on a worksheet in Excel
Comment sent successfully! We will review it in the next few hours.