Validated = (ActiveCell.Value like "#####")

-----Original Message-----
I need to validate what the user inputs in a specific
cell. I have set
validation on that cell for Whole numbers to avoid having
the user type
letters and it works fine but when I run the macro that
promts the user
for the number, validation does not work.

How can I have the macro validate that the input is a
whole number,
with 5 characters and there's no letters?

thanks one more time


---
Message posted from http://www.ExcelForum.com/

.