Does Excel Support the VB List Class?

  • Thread starter Thread starter Benjamin Fortunato
  • Start date Start date
B

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
 
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
 
Back
Top