View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Gary Keramidas Gary Keramidas is offline
external usenet poster
 
Posts: 2,494
Default min and max in a text box

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