Does Excel Support the VB List Class?

[Benjamin Fortunato]

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

 

[Peter T]

What sort of List do you have in mind

Regards,
Peter T

 

[Chip Pearson]

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