Select UserForm from drop down list …

[adambc]

I have a Workbook that opens a UserForm when the file is opened (and does lots of stuff with the data entered) …

I now need to add a number of other UserForms and allow the User to select which one is opened when the file is opened …

I’m thinking about a UserForm with a List, but not quite sure how I use whatever the User selects to pass to the logic that opens the correct UserForm eg …

Can I pass the value to a [variable] within a Sub (without needing to save it anywhere)?

If [variable] = X Then
frmX.show
etc
etc

Can anyone help?

Thanks …

 

[Candyman8019]

You may need to work on the syntax a bit but you would use something along the lines of:

Select Case frmX.{name of dropdown field}.Value
Case "red"
'call form 1'
FormRed
Case "Blue"
'call form 2
FormBlue
Case Else
End Select

 

[adambc]

UPDATE …

I figured this out all by myself!!!

UserForm1 with a ComboBox and a CommandButton …
- loads when Workbook opens
- Initialize populates cbo list
- cmd code sets a variable on the value selected from the cob list
- populates Cell in Workbook used to stor selected value
- Unloads frm
- uses variable in a series of If/Else If/Else/End If statements to load appropriate UserForm

Works perfectly …