Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automatically generate user forms
Okay, I think I'm missing something basic here. I have 2 user forms; i.e.
Games, Players. I want to generate 6 players forms for each number of games entered in the "Games" form. How do I set this up? I have a "Next" button on the "Games" form that will bring up the "Players" form but how do I keep generating the players forms and how do I set up the variables/controls on the "Players" forms to keep track of the information inputed. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automatically generate user forms
Something like this...
'---------------- Private Sub CommandButton1_Click() Dim frmCopy As UserForm Dim sngLeft As Single Dim sngTop As Single sngLeft = Me.Left + 15 sngTop = Me.Top + 15 Set frmCopy = New frmGames With UserForms(UserForms.Count - 1) .StartUpPosition = 0 .Left = sngLeft .Top = sngTop .Caption = "Players " & UserForms.Count .Show End With End Sub Private Sub CommandButton2_Click() Me.Hide Unload Me End Sub '------------- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "Rominall" wrote in message Okay, I think I'm missing something basic here. I have 2 user forms; i.e. Games, Players. I want to generate 6 players forms for each number of games entered in the "Games" form. How do I set this up? I have a "Next" button on the "Games" form that will bring up the "Players" form but how do I keep generating the players forms and how do I set up the variables/controls on the "Players" forms to keep track of the information inputed. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I automatically generate a worksheet. | Excel Discussion (Misc queries) | |||
generate automatically sum | Excel Worksheet Functions | |||
Automatically generate letter | Excel Discussion (Misc queries) | |||
Generate a value from user selection in list box. | Excel Discussion (Misc queries) | |||
Generate & print reports/forms | Excel Programming |