I want to use an ActiveX combobox in an excel sheet.

To populate the combobox, I use a range of cells with the items to so.

When I select an item in the combobox, I would like to know the cell that correspond to the selected item.

For example, if I have in cell J12 the value "Verdadero" and in the cell J13 the value "False", if I select the intem Verdadero, I would like to know in code that the cell is J12.

How can I achieve that in Excel VBA ?

CodePudding user response：

You can use the