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!!
Private Sub GlobalAccount1_Change()
If TbCheck = IsNumeric(GlobalAccount1) Then
MsgBox "This is an invalid entry! Please delete and retype a number "
TbCheck = IsNumeric(GlobalAccount1)