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 will explain another 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 with a data validation box. It looks a bit tangled, but as we've 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 in a simple way 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
To enable us to use and configure the properties of the ActiveX combo box control in Excel, we need to do the following. First enter the program and open your spreadsheet, when you are in it you have to go to the top menu. There you have to select the Developer tab, then Insert and in the ActiveX controls box, click on the combo box option.
When you do, the editing mode will be activated and with the mouse cursor you can draw the control on the Excel spreadsheet. After inserting the ActiveX control, Design Mode will automatically activate. And in this way we will be able to configure the control according to our needs.
Then, to change the properties, we position the cursor on the combo box and click the right mouse button. In the options that will appear we must choose the Properties option and the box with the same name will be displayed. First of all we will configure the property LinkedCell in it we will position 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 shown. Once this is done, we need to place the values that should show combo box. 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 the sellers made in shop 1, shop 2, shop 3, shop 4. Then to get a list in the combo box of sellers. We will go to the property ListFillRange and we will write the following range Store¡B2: B15:
Once this is done, we close the properties window, then go to the top menu and disable the Design mode, and now let's move on to testing the control. After making 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 in the beginning.
Then we paste it in the place we choose and now we will change 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.
This way we finish the tutorial, we just hope you can apply the steps we explained here and practice a lot, so you don't forget this handy Excel function. But you will always have a chance to see this article and review how to use and configure the properties of the ActiveX combo box control in Excel.