Combobox

[Jim Lavery]

I want to show another userform based on the value in the combobox. Simple I
know. any ideas?

 

[FSt1]

hi.
simple maybe. depends. but to answer the simplistic reguest....
Private Sub ComboBox1_Change()
If ComboBox1.Value = "something" Then
otherform.Show
End If
End Sub

regards
FSt1

 

[JLGWhiz]

This is for concept only. Without specific information no valid code could
be developed.

Private Sub UserForm_Click()
If Me.ComboBox1.Value = Range("A1").Value Then
UserForm2.Show
Unload Me
End If
End Sub

 

[Dave Peterson]

I think I'd just use something like:

Select case lcase(me.combobox1.value)
case is = "value1" : userform1.show
case is = "value2" : userform2.show
case is = "value3" : userform3.show
end select

 

[ShaneDevenshire]

Hi,

You could use something like this

Private Sub cboColors_Change()
Select Case Me.cboColors
Case "Red"
frmRed.Show
Case "Green"
frmGreen.Show
Case "Blue"
frmBlue.Show
End Select
End Sub

where you have three forms named frmRed, frmGreen, frmBlue