Array to Populate ListBox Problem

[pallaver]

I have a dynamic array that has two columns, i.e. myarray(7,0)

Reading up on dynamic arrays, it seems like only the last column can
be expanded.

I'd like to populate a listbox using the array, hence something like:

entry.listbox = myarray

Only when this is done, it's the first column that's entered in the
listbox, but I want the second column to be the one to populate the
listbox. I could break it up into two arrays rather than one (and
actually have), but am still curious to see if this is possible.

Thanks. -np

 

[Tausif]

Hi,
Are you intending to populate 1 list box & on the basis of that populate
other listbox?
Just yday, I created something similar for some 1 in the forum & it worked
for him ( & this uses dynamic arrays)

Download the file from rapidshare. I've used a combobox in this example,
which will work fine even for a listbox.

http://rapidshare.com/files/132101437/Book1.xls.html

If yu want to read more the question posted, check the link belo
http://www.microsoft.com/office/com...misc&mid=0f6db7fb-b114-4c12-9f5d-0652a58ec25f

HTH,