put array into listbox as rowsource

J

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
 
M

Marshall Barton

Jesper said:
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?
Click to expand...


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

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.
Click to expand...

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
 
Top