Help with list boxes please.

I need help with a list box.

The list box must contain data that is spread over 25 non-sequential columns
The rows must also be non-sequential (can grow to many) and only contain the search criteria set in a text box and a combobox combined.

textbox2 in the attached file is only there to show where the file is now but I know how the do that one.

List Box History.xlsm

Is there a better way to do it?

Thanks

Thanks for your help but I seem to have a problem with this code - it does not work.
I do believe the problem lies with me though.

Thanks for the advice on the renaming id the objects. I have actually started on that just today.

I found the problem. Some how some spaces in my Initalize routine got lost so the code could never find the value. (I told you that the I was the problem)

Thanks for your help.

Ok. I now know that I need to learn how to use arrays fast.

The code works (now just better) but it crashes if the array source column goes 10 or bigger please help

List Box History.xlsm

Thanks

AddItem method only allow up to 9 columns as far as I remember.

You will need to create an array for the list/column property of ListBox.

e.g

Please Login or Register  to view this content.

I managed to stretch the list to include all the entries but now I get all the columns ad I only want some.

I will try some more but please help.

You can just reduce the size of the list:

Please Login or Register  to view this content.

Where xx is the total number of columns you want.

Then, inside the lngItem loop, just assign the specific columns:

Please Login or Register  to view this content.

and so on, picking and choosing the columns you want. At the bottom, change the last redim to match your columns again:

Please Login or Register  to view this content.

BTW, thank you jindon for pointing out the limitation on .additem and showing a good method for extending the list.

Thanks to Wallyeye and Jindon.

The Code works perfect and I'm happy. (at least for now)