Solved

Excel VBA: Creating dynamic dialog box

Posted on 2001-07-16
4
354 Views
Last Modified: 2008-03-10
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
Comment
Question by:robjay
  • 2
4 Comments
 
LVL 2

Accepted Solution

by:
TrueDrake earned 100 total points
ID: 6286513
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
 
LVL 16

Expert Comment

by:Richie_Simonetti
ID: 6286600
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
 
LVL 16

Expert Comment

by:Richie_Simonetti
ID: 6286609
Or you could add properties to dialog form and fill them with values from user input.
0
 

Author Comment

by:robjay
ID: 6314097
Looks like this is the best choice.  Thanks!
0

Featured Post

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
How to create a duplicate finder Application 9 120
VBA error replacing data 6 39
bit defender blocks good applications 2 93
clicking a shape in a frame array vb6 3 45
The debugging module of the VB 6 IDE can be accessed by way of the Debug menu item. That menu item can normally be found in the IDE's main menu line as shown in this picture.   There is also a companion Debug Toolbar that looks like the followin…
I was working on a PowerPoint add-in the other day and a client asked me "can you implement a feature which processes a chart when it's pasted into a slide from another deck?". It got me wondering how to hook into built-in ribbon events in Office.
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

785 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question