or
Kind regards![]()
Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$F$3" And Target.Value > 99999 Then MsgBox "Numbers may not exceed 99999" Application.Goto Reference:=Range("F3"), scroll:=False End If End Sub
Leo
or
Kind regards![]()
Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$F$3" And Target.Value > 99999 Then MsgBox "Numbers may not exceed 99999" Application.Goto Reference:=Range("F3"), scroll:=False End If End Sub
Leo
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks