View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
David Goodall David Goodall is offline
external usenet poster
 
Posts: 21
Default Userform Date validation

Hi,
I'm currently developing a userform which has a text box that prompts the
user for a date of birth. I would like to validate the input as a correct
date of birth. ie not born before 1900 and in correct dd/mm/yyyy format.

I've had a look at the the isdate function but I'm not sure if it can handle
the British date format.

Any help would be greatly appreciated.

David