Combobox
 

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

Combobox
 

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?

Combobox
 

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?

Combobox
 

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