View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
pallaver pallaver is offline
external usenet poster
 
Posts: 62
Default Array to Populate ListBox Problem

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