Hi,

Anyone know how I can write a macro to set validation on a cell suc
that it will validate whether the date entered is of the form "dd mmm
yyyy" and that it is greater than the date today?

How do I programmatically set the error message?

Thanks for your help

--
junx1

-----------------------------------------------------------------------
junx13's Profile: http://www.excelforum.com/member.php...nfo&userid=562
View this thread: http://www.excelforum.com/showthread.php?threadid=27201