How to create dynamic userform or dialog box

**welchs101** · 03-31-2010, 03:05 PM

I wanted to create a userform that is dynamic. Let me explain.

A teacher is going to give a test. The teacher is going to give two versions of the test. Each test may or may not have the same number of problems.

I want to create a userform that asks how many tests and problems per test. Then, ideally, on the same userform after input the number of tests and problems a list would be created asking the number of possible points for each problem.

The list would ask what the possible number of points are for each problem kinda like the list below. Of couse each col would be labeled but did not do it here.

Test1_Problem1 50
Test1_Problem2 50
Test2_Problem1 50
Test2_Problem2 50

The list would be dynamic in the sense that you dont know how many tests or problems are going to be needed? Does this make sense what i am asking? Is it even possible?

**royUK** · 03-31-2010, 03:31 PM

It's possible, but complicated

**welchs101** · 04-01-2010, 07:54 AM

ok.....

how would you recommend that i get the input from the user on the possible points per problem?

**romperstomper** · 04-01-2010, 08:39 AM

Here's a rough demo of how to go about it.

**welchs101** · 04-01-2010, 09:01 AM

is there a way to "pass" the number of problems to the userform? I can get input from the user on how many tests and problems per tests........then i can pass the total number of problems tothe user form and have it create the desired number of entries instead of having user input the number of entries.

by the way...........very nice what you sent .......

**welchs101** · 04-01-2010, 09:03 AM

also, how do i get the data out of the userform? where is it being stored and how do i get it back to my main program?

**romperstomper** · 04-01-2010, 09:07 AM

You said there could be a different number of problems per test, which is why I made the demo the way it is.
Also, it is just that - a demo. I have no idea of how your application works so I don't know what you plan to do with the data - that bit is up to you!

**welchs101** · 04-01-2010, 09:09 AM

hi,

and thanks for the demo.

I guess what i am asking is "how to transfer" the number of problems to the "userform"?

Once userform is displayed and user types in the appropriate values in each box......how do i get the data?

I am not sure how to transfer the data back to my program so i can access it. Does this make sense?

**romperstomper** · 04-01-2010, 09:15 AM

The userform asks how many tests, how many problems per test, then prompts for a score for each question - is that not what you asked for?
To get the data back you need a loop through the controls on page 2 of the multipage, check if each is a textbox and return the value. They are all named in the format TestxQuestiony so you know what they relate to.

**welchs101** · 04-01-2010, 09:33 AM

hi,

yes that is what i asked for.

But inaddition, how do you pass variables to the userform.

Also, i am still not clear on how to get the data from the userform to my program. I am sorry, i guess i am not as good as i had hoped.

**romperstomper** · 04-01-2010, 09:49 AM

You can fill in the textboxes before showing it using code like:

Sub ShowForm()
   Dim frm as Userform1
   Set frm = New Userform1
   frm.Textbox1.Value = 3
   frm.Show
End Sub

and to return the data, add a button to the second page and use code like:

Private Sub CommandButton3_Click()
    Dim ctl As MSForms.Control
    For Each ctl In Me.MultiPage1.Pages(1).Controls
        If TypeName(ctl) = "TextBox" Then
            MsgBox ctl.Name & ": " & ctl.Value
        End If
    Next ctl
End Sub

This will report the values in a series of messageboxes - you'll need to adjust it to put them wherever you like.

**welchs101** · 04-01-2010, 12:46 PM

I must admit. I have not programmed with userforms that much. I can program ok......but boy....they syntax you have in this is almost foreign to me. There is much to learn.

Thanks again.

Just one more comment.

What i was hoping to do is pass an array or something to the user form , fill the array with the possible points, then pass the array back to the main program........how would one do this? If you dont have time to answer i understand............thanks for what you have done.

i can tell your really good at this stuff......

**welchs101** · 04-01-2010, 12:49 PM

also, when you say "2nd" page......where is the 2nd page?

How to create dynamic userform or dialog box

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

How to create dynamic userform or dialog box

Re: How to create dynamic userform or dialog box

Re: How to create dynamic userform or dialog box

Re: How to create dynamic userform or dialog box

Re: How to create dynamic userform or dialog box

Re: How to create dynamic userform or dialog box

Re: How to create dynamic userform or dialog box

Re: How to create dynamic userform or dialog box

Re: How to create dynamic userform or dialog box

Re: How to create dynamic userform or dialog box

Re: How to create dynamic userform or dialog box

Re: How to create dynamic userform or dialog box

Re: How to create dynamic userform or dialog box

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions