How to do data validation to limit the length of the data?

[shahirslmn]

I have a file for which following requirements should be met.
- B5:B10 can only accept 8 alphanumeric characters
- C5:C10 can only accept numbers from 100 to 999
- D5:D10 can only accept 4 to 8 alphanumeric characters
- optimization of code shifting the repeated part(s) of code in function(s)

we can use default data validation or use macro to do this job. Default data validation can be tweaked by pasting values to the cell. I don't want this to happen.

Please help me on this.

[MarvinP]

Hi shahirslmn,

See if the attached does your problem.

[shahirslmn]

Thank you for helping me on this. But this file can be tweaked by pasting values. I want the file to work even if I paste a value other than in required format.

[MarvinP]

Hi,
Searching the net dosn't give me any answers I like. The best I've found is at:
http://www.officekb.com/Uwe/Forum.as...rom-copy-paste
but it seems to have lots of drawbacks.

[shahirslmn]

Please Login or Register  to view this content.

I have written a fare enough code. Somebody please help me to reduce the number of lines of code in the above macro.
Thanks in advance.