Hi All,

I have a userform for creating job numbers and I would like to read in text files to a listbox on the userform based on finding a certain value in column A of sheet1. Right now I have a search function to find duplicates and also flag specific job numbers that I list on sheet2. What I want to add is the listbox function and once it finds the job listed on sheet2 I would like to read in a specific text file. The userform finds and loads job# 7-123 and now calls to read in text file 7-123.txt How can I do this for as many job numbers as I need? I hope I am making sense.....

Thanks in advance!