ListBox

[GarethG]

I want to read the values in a listbox. How do I reference a particula
index position in a ListBox
i.e.

MyVal = ListBox1.<Value of Index Position 3>

Anyone

 

[Chip Pearson]

Gareth,

Use something like

MyVal = ListBox1.List(2)

The index into the List is 0-based, so 0 is the first item, 1 is
the second item, and so on.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[MSP77079]

ListBox question:
I want to read the values in a listbox. How do I reference a particula
index position in a ListBox


thisItem = ListBox1.List(ListBox1.ListIndex