excel - Get the selected value of a activex combobox using vba

Question

How do i get the selected value of the combobox?

i have a combobox which has the values: "Corporate" and "Consumer".

I want to get the value that i selected, not the index, and store in a string.

something like this:

 string a = combobox.value;

(a -> Consumer)

thank you

Answer 1

If your ComboBox is embedded in a spreadsheet you can use this:

Dim ws as Worksheet
Dim cboCorpConsumer as ComboBox
Dim a as String

Set ws = Worksheets("YourWorksheetName")
Set cboCorpConsumer = ws.OLEObjects("cboNameFromActiveXProperties").Object

a = cboCorpConsumer.Value

Or in one line:

a = Worksheets("YourWorksheetName").OLEObjects("cboNameFromActiveXProperties").Object.Value