Karedog,
I started a new workbook and entered the following into "WorkSheet"
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Address = "$F$7" And Target.Value > 3 Then
MsgBox "Numbers may not exceed 3"
Application.Goto Reference:=Range("F7"), Scroll:=False
End If
Continue:
Application.EnableEvents = True
End Sub
And if I enter a number larger than 3 (into F7)and press enter nothing
But if I now reselect cell F7 it works.
But if have to return manually to F7 every time to make it work.
Bookmarks