I am new to VBA and struggling along. In the attached workbook, I want to run Userform2, have the user choose a response to the listbox, pass the listbox response to the appropriate "codes" to activate a specific worksheet and then run userform1 against the activated sheet. The code I have in Userform2 produces a run-time error '9': Subscript out of range error. Please advise and thank you very much for your assistance!!