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

Hi
a non-VBA solution. Try: 'Data - Validation' and choose 'Date' together with
your starting date.

"junx13" wrote:


Hi,

Anyone know how I can write a macro to set validation on a cell such
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!


--
junx13


------------------------------------------------------------------------
junx13's Profile: http://www.excelforum.com/member.php...fo&userid=5620
View this thread: http://www.excelforum.com/showthread...hreadid=272016