Jim - couple of weeks old this post but I'm looking for the validation that
you mention
I've got a userform so admin staff can enter employee details and part of
that is start/finish date. I wanted to cheat really and try and get Excel to
validate the date entered for me, rather than have to type the code, and to
that extent I've tried using DateSerial to create a date with no luck.
I was thinking about putting the date into a cell on a hidden worksheet to
validate it but it seems a little "clunky" to me. Is this the best way for me
to validate the dates entered unless I write out some lengthy validation code?
Thanks
George
McCloudK - hope you don't mind me pinching the post