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?