Bound Combo box in userform

[Guest]

Hello Hello,
I have a userform with a bound combo box, I have it set as so . . .
BoundColumn: 2
ColumnCount:1
I would like the value in the first column to be placed on Sheet1 and the
value in the second column placed in Sheet2. I am not having any problems
with Sheet1 its getting the second value to the second page without having
the user reselect the data. Ideas?

Also, i am using xl2000 and when i try to use vlookup or lookup for that
matter in vba it says its not supported. Any way around that or am i stuck.
Thanks for the help. Jennifer

 

[Ivan Raiminius]

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

 

[Guest]

You got it! Thank you!