How about using Data Validation, which has a date type, and you can specify
upper and lower limits on the date.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Jenni_Sweden" wrote in message
...
Hi I am writing a macro in VisualBasic 6.3. In an Excel-spreadsheet the
user
is supposed to write two dates in two different cells. When pressing a
button
defined in my macro the dates submitted by the user shall be stored as a
variable and checked. The checking is to see that the date is written
properly e.g. YYYY-MM-DD. How do I preform this check? Is it possible to
see
if the dates gives by the user are non-existing? Any help is appreciated!