Dear friends
i want to see that user inputs only six digits in the cells in the column C. it is from C2 to C3500.
i tired this code & it is working for C2 . but how to extend it to the whole column that is up to C3500.
early reply is appreacited
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Count > 1 Then Exit Sub
If Target.Address = "$C$2" Then 'Change cell address to suit
If IsNumeric(Target.Value) = False Or Len(Target.Value) <> 6 Then
MsgBox "Only 6 digit numeric values are allowed."
Application.EnableEvents = False
Range("C2").Application.Undo
Application.EnableEvents = True
Exit Sub
Else
End If
End If
Bookmarks