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" <(E-Mail Removed)> wrote in
message news:8CBF362B-4723-46ED-A0FA-(E-Mail Removed)...
>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
<(E-Mail Removed)> 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