I have an excel spreadsheet with a list of names and member ID numbers. I am trying to create a vba user-form to lookup the members ID by searching for the member’s name. An example would be in a textbox I type “John” and in a list box it will only display all the names that contain the word “John”.
Also, if I click on the one of the names, it will copy the member ID to the spreadsheet.
I attached my excel workbook.
Thank you in advance.