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

userform help
 

Do a little truth table:

Entry <"M" <"N" <"M" Or <"N"

M FALSE TRUE TRUE
N TRUE FALSE TRUE
A TRUE TRUE TRUE

I suspect your want "And" instead of "Or"

Entry <"M" <"N" <"M" And <"N"

M FALSE TRUE FALSE
N TRUE FALSE FALSE
A TRUE TRUE TRUE



In article ,
"Gary Keramidas" <GKeramidasATmsn.com wrote:

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

userform help
 

Because your test drives it that way.

If it is equal to M, it will pass the < "N" test
If it is equal to N, it will pass the < "M" test
If neither N nor M, it will pass the < "M" test

Are you sure you don't mean AND instead of OR


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Gary Keramidas" <GKeramidasATmsn.com wrote in message
...
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

userform help
 

i only want to accept M and N as possible entries, nothing else.

--


Gary


"Bob Phillips" wrote in message
...
Because your test drives it that way.

If it is equal to M, it will pass the < "N" test
If it is equal to N, it will pass the < "M" test
If neither N nor M, it will pass the < "M" test

Are you sure you don't mean AND instead of OR


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Gary Keramidas" <GKeramidasATmsn.com wrote in message
...
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

userform help
 

See my reply.

In article ,
"Gary Keramidas" <GKeramidasATmsn.com wrote:

i only want to accept M and N as possible entries, nothing else.

--

userform help
 

and seems to work, thanks

--


Gary


"JE McGimpsey" wrote in message
...
See my reply.

In article ,
"Gary Keramidas" <GKeramidasATmsn.com wrote:

i only want to accept M and N as possible entries, nothing else.

--