robjay
asked on
Excel VBA: Creating dynamic dialog box
I have a UserForm that takes input from the user and I need to create a dialog box that will appear after the UserForm is filled out and the content will be based on input from the UserForm, i.e. a list of row options will be given for the number of rows specified in the first UserForm. Any code examples . . .
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Maybe creating a public sub in a module that should be fill some variables with user input data and, when load second form/dialog, reading contents of those vars.
Or you could add properties to dialog form and fill them with values from user input.
ASKER
Looks like this is the best choice. Thanks!