View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Luis Verme Luis Verme is offline
external usenet poster
 
Posts: 8
Default Validating Dates

I'm trying to validate dates whuen I make an input ("dd/mm/yy"). I use the
routine

If IsDate(txtFFinal) Then
MsgBox "Date is correct"
else
MsgBox "Date is correct"
End If

When I enter the date 31/06/2005 it assumes it's a correct date.

Any suggestions?

Thanks

Luis Verme