Populate a Userform from a selection on a popup search listbox

Hello Everyone,

This my very first post on this forum. I have been reading through the threads and I was able to troubleshoot and fix my way through a lot of my problems. However I am now stuck on the last part of my project.

I have a spreadsheet with information on it. I have created a search button on a userform. I type in either the project number or the project name, and then hit enter. The Userfom populates with the information of the first search result, and a popup listbox appears with all the search results.

I want to be able to choose an item from the listbox, and have the information of that search result populate the first userform. I CANNOT for the life of me figure out how to do that.

I would really appreciate it if anyone can help me with what seems like an impossible task to accomplish.....

Ahmad

Try this one.

You are you a wonderful human being...

I do have one question though. The search now is limited to the Project number (column 4), is there any possible way I can make the search include the Project name (column 3) and the project number (column 4) ??