If Grade.text = 1006, then I don't want the user to be able to put certain values into the C textbox. The value needs to be >= 0.04 and <= 0.06. If they enter any other value, I want a message box to appear saying that the value is not valid.
Expand|Select|Wrap|Line Numbers
- Private Sub C_Enter()
- GRADE.SetFocus
- C.Locked = False
- If Trim(GRADE.Text) = "1006" Then
- ElseIf C.Value >= 0.04 Then
- MsgBox "Value must be between 0.04 and 0.06"
- ElseIf C.Value <= 0.06 Then
- MsgBox "Value must be between 0.04 and 0.06"
- Else
- End If
I'd really appreciate any sugguestions someone might have.
Thanks