Populating a userform based on a listbox selection

I have come across an issue while trying to put together a spreadsheet. I am trying to create a database that will have 14 colums and an unlimited amount of rows. With the help of the amazing people of this site i have been able to make great progress. But i am at a roadblock.

I now know that a listbox can only populate 10 colums. After conducting a search the listbox populates all matching rows up to the tenth column. When i click on one of the matching rows only the first 10 boxes on the userform populate. i cannot for the life of me figure out ho to get the other 4 boxes to populate.

is there a way that i can select the appropriate row and then use offset to populate the userform?

Any help would be greatly appreciated.

A listbox can have more than 10 columns, you just can't use Additem to populate it if it does. You need to create an array of your data and assign it to the listbox's List property. You can also set its rowsource to a range on a sheet but IMO you are better off using an array.

Every time I run a search there seems to be missing TextBoxes

Use Excel's builtin facilities:
And put this in the Initialize-event

Please Login or Register  to view this content.

And

Please Login or Register  to view this content.

Hi hey1000

or maybe

Please Login or Register  to view this content.

I've changed Findall2,this needs adapting & should be made more dynamic so that you don't need so many procedures that are similar. You could maybe use the Tag property to store the relevant Column reference for each TextBox

I have changed the number of Columns to 14 in the listBox

snb, why CurrentRegion? It won't work with a filtered range as required.

Delete the code in the Find All Button& paste this codein

Please Login or Register  to view this content.

The code will loop through each control& if it is a TextBox or ComboBox and it has a value in it then it will use that value as the criteria to filter for. The Field is decided on that controls Tag property which must be the corresponding column number. See the first TextBox & ComboBox,they are the only ones that I have set up.

You can then delete all those FindAll procedures

I suggest that you read up on the use of the key word Me,you don't use it correctly

It worked fine for me in the example you attached