Data Validation problem

[placasse]

Hi,
I am trying to do Data Validation on a cell in order to prevent the user to enter text data that has a lenght outside the range of 1 to 10 characters.

I use the Data Validation feature in Excel and select Input Lenght and put 1 as the minimum and 10 as the maximum and uncheck "Ignore blanks".

It does work OK except when I select the cell and hit the Delete key, the data validation doesn't trigger but the cell is empty meaning it has a count of 0 character.

Any idea why ?

Pierre

 

[exAHSacto]

Are you using VBA?

/Anders

 

[rafaelspeixoto]

Excel always worked like this. You can delete the value even if the validation requests 1-10 digits. You just can't enter the cell, delete the contents and press enter.

I don't know a work around for this issue, except for vba.

 

[placasse]

Hi,
thank you for the replies. I am not using VBA for the Data Validation.

If I Delete & Enter the cell, it doesn't validate either.

What will be an easy VBA to check this ? I supposed Worksheets Change Event...


Thank you