Hi
for a macro solution you would need a worksheet_change event handler which
checks the value of the entered data.
e.g. using
IsDate(target)

See:
http://cpearson.com/excel/events.htm

"junx13" wrote:


Hi,
thanks for the reply, but as my worksheets are dynamic, I need to
do this programmatically and thus my request for any inkling on how to
do a macro to do this... thanks anyway!


--
junx13


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