How to read only one column from a ListBox object? (into an array)

[Helghan]

Hi!

I have an activeX ListBox object on one of my sheets. I have a macro that pulls the list items from the ListBox and stores them in an array.
For this purpose I am using:

Please Login or Register  to view this content.

My problem is that now I get a two-dimensional array (with lots of null columns), even though I only need the values from the first column of the ListBox (as a one-dimensional array).

I tried using:

Please Login or Register  to view this content.

But this gives me only the first row of the first column (so only one item).
Is there a way to store the items of a single column from the ListBox in a one-dimensional array?

Thanks for all the help in advance!

[jindon]

Try

Please Login or Register  to view this content.

Correction;
Missed

(as a one-dimensional array).

[Andy Pope]

Not a single dimension array but it is a single column.

This should display 1st and last item in second column

Please Login or Register  to view this content.