Numeric Value of Choice in Combobox

[WLMPilot]

Once an item is chosen from a combobox, how do I determine the corresponding
numeric value of that choice?

I need that value in order to pull in another value from the spreadsheet.

Thanks,
Les

 

[Per Jessen]

Once an item is chosen from a combobox, how do I determine the
corresponding
numeric value of that choice?

I need that value in order to pull in another value from the spreadsheet.

Thanks,
Les

Hi Les

Private Sub ComboBox1_Change()
choice = Me.ComboBox1.ListIndex
End Sub

Just remember that first item will be equal to index = 0

Regards,

Per

 

[WLMPilot]

Thanks! One more quick question. Do the textboxes, comboboxes, etc have to
be DIM or is it automatic?

Thanks,
Les