View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Per Jessen Per Jessen is offline
external usenet poster
 
Posts: 1,533
Default 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