Is there a way to specify that a Date format can only be
in MM-DD-YY, not MM/DD/YY?

If Answer = "" Then Exit Sub
If Not IsDate(Answer) Then
MsgBox "Invalid Date!"
Exit Sub
End If

This will confirm that it is a date, but won't distinguish
between / and -.

Thanks

S.