excel - Get Selected value of a Combobox

Question

I have a thousands of cells in an Excel worksheet which are ComboBoxes. The user will select one at random and populate it.

How do I get the selected ComboBox value? Is there a way to trigger a function (i.e. an event handler) when the ComboxBoxes has been selected?

Answer 1

You can use the below change event to which will trigger when the combobox value will change.

Private Sub ComboBox1_Change()
'your code here
End Sub

Also you can get the selected value using below

ComboBox1.Value