Hi everyone,
how can i have a minimum value to a cell i.e you have to enter 6 digits
my current code stops someone entering a letter and the max length is set in the vb properties but now im lost!!
my code:
Private Sub GlobalAccount1_Change()
Dim TbCheck
If TbCheck = IsNumeric(GlobalAccount1) Then
MsgBox "This is an invalid entry! Please delete and retype a number "
End If
TbCheck = IsNumeric(GlobalAccount1)
End Sub