Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Listbox to Array
I was looking for a faster way to get all the values in a listbox. I have
this code: Dim vArray As Variant dim strCSV as String vArray = Lbox.List strCSV = Join(vArray, ",") but it returns a two dimentional array of (n, 9) bounds, with nulls in the 1-9 entries of every array, which can't be used in Join. The listbox has only 1 column in the properties. Is there anyway to get a one dimentional array from a listbox? The listbox is programatically filled so it is not getting it's source from a worksheet range. Thanks. -- ********************* J Streger MS Office Master 2000 ed. MS Project White Belt 2003 User of MS Office 2003 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Array in Listbox? | Excel Programming | |||
populating a listbox from an array | Excel Programming | |||
How do I pass an array to a listbox? | Excel Programming | |||
ListBox array | Excel Programming | |||
Listbox and Array questions | Excel Programming |