I am trying to bring up a msgbox if the number they enter into cell ("F3") is greater than 99999.
also if this is true I want it to select ("F3") again so they can try again.
I have the following code and I thought it should work but it doesn't.
Any thoughts?
![]()
Private Sub Worksheet_Change2() Dim JobNo As Integer, result As String JobNo = Range("F3").Value If JobNo > 99999 Then MsgBox "Numbers may not exceed 99999" Range("F3").Select End If End Sub
Bookmarks