|
Posted to microsoft.public.excel.programming
|
|
|
IsDate
http://www.rondebruin.nl/calendar.htm
--
Regards,
Tom Ogilvy
"april27" wrote:
yes that would be nice but I dont know how to do it. any clue? :-)
"Norman Jones" skrev:
Hi April27,
I am writing a macro for an Excel spreadsheet. in a user form i have a text
field. in this field the user shall enter a date. the program shall then
revise the date and return an error message if it is not a date. I try to
use
the IsDate function but i dont know how to use it and my help menu does
not
give me any info on this. anyone?
Why not use a calendar control for date entry?
---
Regards,
Norman?
|