Does Excel Support the VB List Class?
 

I have one quick question. Does Excel support vb Lists? I wanted to add some
data to a vb list via the list.add method, but excel does not support the
format

dim Mylist as list(of double)

Does this mean I have to use the array class?

Best,

Ben

Does Excel Support the VB List Class?
 

What sort of List do you have in mind

Regards,
Peter T


"Benjamin Fortunato" wrote in
message ...
I have one quick question. Does Excel support vb Lists? I wanted to add
some
data to a vb list via the list.add method, but excel does not support the
format

dim Mylist as list(of double)

Does this mean I have to use the array class?

Best,

Ben

Does Excel Support the VB List Class?
 

No, VBA doesn't support of any the System.Collection.Generic classes
that you get with VBNET. You can use a regular Collection or if you
reference the Microsoft Scripting Runtime you get a Dictionary object.
Neither of these are strongly typed.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional,
Excel, 1998 - 2010
Pearson Software Consulting, LLC
www.cpearson.com



On Mon, 1 Mar 2010 07:25:01 -0800, Benjamin Fortunato
wrote:

I have one quick question. Does Excel support vb Lists? I wanted to add some
data to a vb list via the list.add method, but excel does not support the
format

dim Mylist as list(of double)

Does this mean I have to use the array class?

Best,

Ben