Controlling date input

[southpawDiscGolf]

I realize that this is a continuation of a previous thread but after going back and forth ten times, I'd thought it best to re-ask the question.

I want the user to have total flexibility to input date information in any format that they desire - either with or without slashes and have the system be smart enough to interpret the input and make the necessary changes.

Can this be controlled entirely within VBA? Do I need to use user-forms?
Any advise would be greatly appreciated. The problem that I was having with the my code was when the cell has a date in it and the user wanted to change the date by entering 7468 (for July 4, 1968) the system interprets this to be 6/11/1920. My code was in the preliminary stages (mainly taken from Chip Pearson web site with some small modifications).

 

[Jeffrey Green]

Any reason why you can't just use Validations ???

 

[southpawDiscGolf]

Using validation doesn't work, if you it set up to accept dates from 1/1/1900 to today()

and you enter 7/4/08 - the system accepts it

if you then key in 7408 (the system accepts it and changes the date to 4/12/1920) not the desired 7/4/08. I want the system to be smart enough to know what the person intended.