MichaelSchulz
Board Regular
- Joined
- Apr 10, 2014
- Messages
- 64
Depending on the situation the value for a certain variable can be pulled directly from the workbook.
In other situations, it will be best to prompt the user to make a selection from values that are pulled from the workbook.
I have created a UserForm that displays under the right conditions and at the appropriate time, and it contains a ListBox that is properly populated.
What I do not know is how to structure the code that calls the UserForm such that it "waits", so to speak, for the user to make a selection and then continues.
Also, at this point in the code a number of values have been assigned to other variables and I do not wish to lose those values.
What is the best way to obtain user input while in the middle of the code?
In other situations, it will be best to prompt the user to make a selection from values that are pulled from the workbook.
I have created a UserForm that displays under the right conditions and at the appropriate time, and it contains a ListBox that is properly populated.
What I do not know is how to structure the code that calls the UserForm such that it "waits", so to speak, for the user to make a selection and then continues.
Also, at this point in the code a number of values have been assigned to other variables and I do not wish to lose those values.
What is the best way to obtain user input while in the middle of the code?
Last edited: