View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
R-Enemy R-Enemy is offline
external usenet poster
 
Posts: 10
Default Date Validation?

I have a text box for dates. How do I validate whether it
is a date or not? I have tried the isDate() function and
it seems to return false sometimes and true other times. I
want to use either mm/dd/yy or mm/dd/yyyy format, it
doesn't matter. If anyone has used TaxCut, their textboxes
automatically places the "/" while typing and wont let you
put anything in other than a valid number, this forces the
correct mm/dd/yyyy format. Is this possible with VB.

Thanks for any help.