Numeric Value of Choice in Combobox
"WLMPilot" skrev i en meddelelse
...
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
|