msgbox "You have not entered a valid date - please retry
this would go in the exit event of the text box
> 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?