Thread: userform help
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 userform help

can someone tell me why i get the message box no matter what i type in? if i
only use 1 condition, it works, as soon as i add the second, nothing works.

If UCase(Trim(Me.LSite.Value)) < "M" Or _
UCase(Trim(Me.LSite.Value)) < "N" Then
Me.LSite.SetFocus
MsgBox "Please Check Site"
Exit Sub
End If

--


Gary