Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 445
  • Last Modified:

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 . . .
0
robjay
Asked:
robjay
  • 2
1 Solution
 
TrueDrakeCommented:
Hi,

It seems that you are using Excel.
I would put option buttons and I would place the resulting choice in a cell of a sheet. I would then do whatever I wanted depending of this cell's value.
Enjoy
0
 
Richie_SimonettiIT OperationsCommented:
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.
0
 
Richie_SimonettiIT OperationsCommented:
Or you could add properties to dialog form and fill them with values from user input.
0
 
robjayAuthor Commented:
Looks like this is the best choice.  Thanks!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now