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/