ListBox

G

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
 
C

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
 
M

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
 
Top