Search and display results to listbox

Hello,

I have a userform1 that allows users to search :

Data on sheet2

and results on sheet1
userform1.PNGData.PNGResults.PNG


End user inputs 142 and search, this should display results in listbox that have all matching title : 142. with the total of 7 columns

The end user would be able to select the correct one and add the results with a click of a button to sheet1 for print.

Curently my code consist of msgbox but the clicking is not helpful.

Please Login or Register  to view this content.

This is fundamentally wrong.

You need a search routine to find your matching entries

Once found the entries are used to populate a list box

Clicking on the listbox should then pull up the selected data.

study this userform:-

What is the purpose of this part of the code?

Please Login or Register  to view this content.

I am getting a Run-Time error '9':
Subscript out of range

shows highlighted

Please Login or Register  to view this content.

Current Code:

Issues:
1. listbox additem is adding like a text, I need to have columns and set the first column rows with a better understanding for end user
Title, Company,Lastname, Address, City, State, Zipcode with a auto adjust column size if possible?

2. output when data is select from listbox needs to be only on column B8,B9,B10, B11 not being added list a list when selected again.

Please Login or Register  to view this content.