View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ivan Raiminius Ivan Raiminius is offline
external usenet poster
 
Posts: 258
Default Bound Combo box in userform

Hi Jennifer,

I am not sure that I fully understood your scenario, so this is just
guess what you need:

value=combobox1.list(combobox1.listindex,1)

value is from second column (first column is 0), from selected row. If
nothing is selected (listindex = -1), you will get an error (so you
must check first if something is selected (listindex<-1)).

Please let me know if you need more help.

Regards,
Ivan