Parameter Max Rule

[ASchlaack]

I have a form to adjust a parameter that has a max value of 240 in. How can I write a rule to not let anything higher than that be entered and have a message box come up saying that a value thats too high was entered?

[mrattray · Accepted solution]

If myParameter > 240 Then
   msgbox("Value too high",vbOKOnly,"No dice")
   myParameter = 240
End If