Bound Combo box in userform

[Jennifer]

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
--
Though daily learning, I LOVE EXCEL!
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

[Jennifer]

You got it! Thank you!
--
Though daily learning, I LOVE EXCEL!
Jennifer


"Ivan Raiminius" wrote:

> 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
>
>