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
|