• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 433
  • 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

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

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