using Or statement

[d0uga1]

can someone help me im trying to use the Or statement in a project

i have a checkbox which gets checked when i click a label then i want to see if when a cmd button is clicked weather the outcome is in the fist 10 numbers or the second. bit like a roulette table

the code i have which isnt working(that i need help on) is this

Private Sub lblEndResult_Change()
if Check1(0).Value = 1 then
   if lblEndResult.Caption >0 Or <10 then
   MsgBox "Number is Less Than 10",vbOkOnly, "Less Than 10"

end if
end if
End Sub

now when i try to use this code it comes up in red telling me its not gonna work. why?

can i not use the Or statement here.

[d.paulson]

Change to
if lblEndResult.Caption >0 Or lblEndResult.Caption<10 then
but I think you want an And instead of the Or

[d0uga1]

ThankYou It Worked A Treat.

[Shuja Ali]

I would add another bit to this condition

If Val(lblEndResult.Caption) > 0 Or Val(lblEndResult.Caption) < 10 Then

This way, I would be sure that even if there is a string the caption my program won't crash. You can test your code by putting a non-numeric Caption to the label and see how it blows up.