Do not allow user to enter wrong number

[fabian_76]

Hi, users enter in Column "I" multiple numbers such as 014320008006, or 87569387900 and so forth. What is not valid is to enter values ending in triple 0 such as 014320008000 or 0193879000.

What would be a code to automatically advise the user that the number is incorrect, clear data and tell him to enter a correct number?

Thanks,

[MrShorty]

Are you required to use VBA? Excel has a built in Data validation feature that can be set up to do this. https://support.office.com/en-us/art...6-eff3ce5f7249 Set up the data validation to custom and set the formula to =MOD(A1,1000)<>0 -- which will tell Excel to allow any entry that is not an even multiple of 1000, but will block any entry that is an even multiple of 1000.

[fabian_76]

Hi thanks for the quick reply. Yes I am looking for a VBA solution.

[Logit]

.
This macro works here.

Paste this in the Sheet level module of the target sheet :

Please Login or Register  to view this content.

[fabian_76]

thank you so much, it worked!!

[Logit]

.
You are welcome.