dim wrote:

Thanks Bob, your helping me out a lot lately! :-) And Ken I appreciate the
variation, I had'nt come across the 'Or' ability yet and it'll be very handy.

So one more question stemming from that........how many of the
'Or' can I use in a single line statement?
If...< 0 Or Range...125 Or Range...<24 Or Range....82 Or Range < 6 etc ...
Then...

Thanks again.

"Ken Johnson" wrote:


On Dec 30, 8:27 am, dim wrote:

Hi folks,

Can someone please try and debug this code for me? ARGHHHH!! I just don't
get it, why am I getting the compile error, there is obviously an 'If' so why
is it saying there's not?

If (Range("D9").Value) < 0 Then Range("D9").Select: Selection.ClearContents:
UserForm6.Show
ElseIf (Range("D9").Value) 125 Then Range("D9").Select:
Selection.ClearContents: UserForm6.Show
End If

Thankyou for any advice.

If Range("D9").Value < 0 Or Range("D9").Value 125 Then
Range("D9").ClearContents: UserForm6.Show
End If

Ken Johnson

Probably limited to compiler input line length.