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.