View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Matt[_41_] Matt[_41_] is offline
external usenet poster
 
Posts: 30
Default Passing a list to an array

Just curious to know if it is possible to convert a listbox of values
to an array, such as:

Dim arrA as variant
with me.listbox1
arrA = array(.list)
end with

Seems like functionality that would make sense.
It's a pain to do the for i = 0 to .listcount - 1 thing to
create an array.

TIA,
Matt