ListBox
 

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

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com

ListBox
 

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


"GarethG" wrote in message
...

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

MyVal = ListBox1.<Value of Index Position 3

Anyone?


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from
http://www.ExcelForum.com/

ListBox
 

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

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com