VBA Value Range

morlan

Registered User.
Local time
Today, 02:26
Joined
Apr 23, 2003
Messages
143
If me.Control IS Between Value and Value

Just a quick one.

I need to check if control's value is between 10 and 20. How do I do this?

If me.Control IS Between Value and Value
 
If Me.Control >= 10 And Me.Control <= 20 Then
'do this
End If

"Between" is used in criteria expressions. It's not a VBA operator.
 

Users who are viewing this thread

Back
Top Bottom