is there a command button on the form that will open either form?

--


Gary


wrote in message
...

I have a textbox in a user form
when an operator enters a number between 1500 and 1700 I want it to
open userform5 if is is above 1700 or below 1500 I want it to open
userform17

Thanks

Stephen

I have a textbox in a user form
when an operator enters a number between 1500 and 1700 I want it to
open userform5 if is is above 1700 or below 1500 I want it to open
userform17

Thanks

Stephen

this may work for you, i used a command button on userform1

Private Sub CommandButton1_Click()
If Me.TextBox1.Value = "" Then
MsgBox "enter a number"
Exit Sub
End If
If Me.TextBox1.Value 1500 And Me.TextBox1.Value < 1700 Then
UserForm5.Show
Else
UserForm17.Show
End If
Unload Me
End Sub


--


Gary


wrote in message
...

I have a textbox in a user form
when an operator enters a number between 1500 and 1700 I want it to
open userform5 if is is above 1700 or below 1500 I want it to open
userform17

Thanks

Stephen