Thread: MAcro for validation of Date
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
  
Posts: 3,885
Default MAcro for validation of Date
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


Reply With QuoteReply With Quote