creating dynamic number of rows in a listbox

[anandvh]

Hi,

I am writing an application to load the number of members that match a criterion into a ListBox in a Userform. This is a multicolumn array

To start with I have defined the array with the maximum number of members that can be possibly populated into this list box. However, I find that if the actual number of members is less than the maximum number, blank rows are created in the ListBox. My code is as follows:

Please Login or Register  to view this content.

I tried to redim the array using the actual number of records populated which is the value for AryRow

Please Login or Register  to view this content.

This always gives me an error.

Hope some one will be able understand my code and help me with restricting the ListBox entries to the actual records populated

Anand

[Tinbendr]

You'll have to test for a blank cell and NOT add that to the array. Or you could do this.

Please Login or Register  to view this content.

Since you are already iterating the cells, why not just add them to the listbox as you go? Instead of iterating to add them to the array, then adding them to the listbox.

[nilem]

Hi Anand
you can try something like this

Please Login or Register  to view this content.

[anandvh]

thanks tinbendr for your response. When I tried it out, the list box was blank.

Nilem - Thanks to you also for your response. Your code seemed to work, needed a small tweek to get it running as required. I have not understood the need for the transpose, but will probably get it some time later.

Anand