ListBox

  • Thread starter Thread starter GarethG
  • Start date Start date
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
 
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
 
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
 
Back
Top