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

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

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