List Box List Index and Values

[t0m46]

Hey all,

I want to be able to get a Item value from a List based on the List Index.

Eg;

Value List Index
Orange 0
Pear 1
Apple 2

so if the index is 0 it returns the value Orange. I then want to be able to assign it to a variable.

I have tried code like this but it doesnt work.

Please Login or Register  to view this content.

any ideas would be great.

thanks

tom

[royUK]

What kind of ListBox and please wrap all code with code tags

[t0m46]

Hey Sorry, forgot.

Its a Listbox thats on a user form. a command button is pressed and i want to be able to get the all the items in the list box out .

Thanks

[Andrew-R]

ListIndex returns the index of the currently selected value in the list. If you know which value you want to retrieve then you can use a literal...

Please Login or Register  to view this content.

If you want the currently selected value then the code would be:

Please Login or Register  to view this content.

[royUK]

If it is a single columnm without MultiSelect

Please Login or Register  to view this content.

[t0m46]

Hey Thanks,

works a lot more efficent than i had it.

Was using a load of With......If.....Do.

Thanks again.

Tom