multiple frames with sa
I have create multiple user forms to accept variables for editing and process. 2 problems that I don't know how to handle:
1. One of forms I have is to capture 5 sets of responses that users reply. Each set is consisted of 4 questions. Instead of coding individual combobox1, combox2, textbox1, textbox2, ...etc, which is lengthy, and looks redundant. Is there a way that I can cut down the code so that I can utilize the same code and apply for each set of questions? Since functionality for each set of questions is the same.
2 Once I capture all the variables from the user, how do I make the VBA go back to the main module which starts out the first form?
Any assistance, greatly appreciate.