In the attached workbook I have two userforms. I would like for userform2 to allow the user to pick a response from the listbox, then when the user hits the enter button the worksheet title from the user response should activate the specific worksheet with that name, and then userform1 should be shown and the records from the activated worksheet should be used to populate the userform1. I have commented out the code in userform2, because the errors stop the process and the code in userform1 will not work. Also, a previous question was answered for me with the code in userform1, which currently loops through the specific worksheets. I now want to the user to choose the worksheets as described above rather than loop through them.
Thank you very much for your assistance!