Getting value of specific Listbox Item

[Aphis]

Hello,

Let's say you create a listbox and populate it with values. Is there a way to get the value of a specific listbox item?
So let's say i want to get the value of the item that is in the 3rd position in the listbox, can i do that?

Thank you.

[mikerickson]

What kind of list box, user form, ActiveX or Forms menu?

For a list box from the forms menu, it would be

Please Login or Register  to view this content.

[Trebor76]

Normally you use the item that's been selected, but this will put the value of the third item (as long as there is one) from a list box called ListBox1 on an userform into a message box so you adapt it as you need:

Please Login or Register  to view this content.

Note the the number is actually one less than the required number as the first list box index number is zero.

Regards,

Robert

[Aphis]

thaks Trebor, works like a charm.

[Trebor76]

You're welcome. If you could mark the thread as solved it would be appreciated.