Link to home
Start Free TrialLog in
Avatar of robjay
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
Avatar of TrueDrake
TrueDrake

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Richie_Simonetti
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.
Avatar of robjay
robjay

ASKER

Looks like this is the best choice.  Thanks!