When the developers of the Excel program launched this powerful tool on the market, they had no idea of the impact it would have within Office Automation.
It is that within the great variety of tools that we can find, it has a very wide range of action. And it is good that you know where it is installed on our PC and then we are going to explain one more function that will allow you to use and configure the properties of the ActiveX combo box control in Excel.
We have already touched on this topic and we have shown you several ActiveX controls and now it is the turn of the combo box, its use and configuration. With it we can have several options, starting from a Data Validation box. It seems somewhat tangled, but as we have always told you, working with these controls is extremely simple.
Now you will find an article that will teach you how to create an image catalog using the ActiveX image control in Excel, something very simple, believe it or not. But here we will explain easily and with simple steps how to use and configure the properties of the ActiveX combo box control in Excel.
How to use and configure the properties of the ActiveX combo box control in Excel
In order for us to use and configure the properties of the ActiveX combo box control in Excel, we must do the following. First, enter the program and open your spreadsheet, when you are in it you must go to the upper menu. There you must select the Developer tab, then Insert and in the ActiveX controls box, you click on the combo box option.
By performing this action, the Edit Mode will be activated and with the mouse cursor, you can draw the control on the Excel spreadsheet. After we have made the insertion of the ActiveX control, the Design Mode will be activated automatically. And in this way, we will be able to configure the control according to our requirements.
So to edit the properties, we position ourselves with the cursor over the combo box and we are going to right-click. In the options that will be displayed, we must choose the Properties option and the box with the same name will be displayed. First of all, we are going to configure the LinkedCell property in it we are going to place the cell where we want the results to be displayed.
This means that when we choose an option, in the cell that we will indicate in this LinkedCell property, the result will be displayed. Once this is done, we must place the values that the combo box should show. So when we click on the tab, it shows the different options and from which we can choose one.
Setting the properties of the ActiveX combo box control in Excel
For example, if we are talking about a file that shows us the different sales that sellers have made in-store 1, store 2, store 3, store 4. Then to obtain a list in the combo box of sellers. We are going to go to the ListFillRange property and we are going to write the following range Store¡B2: B15:
Once this is done, we close the properties window, then we go to the top menu and deactivate the Design Mode, and now we go on to test the control. After doing the checks we will insert a new combo box. In it, we can compare the sales of two sellers, to do this we copy the combo box that we created at the beginning.
Then we paste it in the place we choose and now we will modify its configuration, first we change the cell where the results will be displayed. So in LinkedCell, we place another cell, we exit or close the properties window and we can check and compare the results.
In this way we finish the tutorial, we just hope that you can apply the steps that we explained here and practice a lot so that you do not forget this practical Excel function. But you will always have the possibility to see this article and review how to use and configure the properties of the ActiveX combo box control in Excel.