put array into listbox as rowsource

[Jesper F]

I'd like to put a 2-dimensional array into a listbox as the rowsource - is
that possible without looping the array and creating a very long text
string?

Jesper

 

[Marshall Barton]

I'd like to put a 2-dimensional array into a listbox as the rowsource - is
that possible without looping the array and creating a very long text
string?

You can do that by using user defined function call in the
box's RowSourceType property. Check VBA Help for all the
details.

 

[Jesper F]

I'd like to put a 2-dimensional array into a listbox as the rowsource - is

You can do that by using user defined function call in the
box's RowSourceType property. Check VBA Help for all the
details.

Thanks, I didn't know that. It's looks a bit complicated, but I'll see I can
get it to work.
Otherwise I may come back here.

Jesper