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

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

"Jim Lavery" wrote:

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

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

"Jim Lavery" wrote:

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

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




Jim Lavery wrote:
>
> I want to show another userform based on the value in the combobox. Simple I
> know. any ideas?

--

Dave Peterson

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

--
Thanks,
Shane Devenshire


"Jim Lavery" wrote:

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