Smithgall
Board Regular
- Joined
- May 24, 2006
- Messages
- 68
I have a text box on a user form that accepts a date. The userform has to handle the conversion rathern than a cell format.
this is what i am using
TextBox1.Value = Format(TextBox1.Value, "mmmm dd, yyyy")
But if the user puts in 041670 i get January 31, 2014.
what is the best way to handle this? I assume the solution is somewhere in forcing the user to type the date in the text box in a specific way. Since i am striving for consistancy. what is the best way to make sure they do this everytime. Or does the solutio lie elsewhere?
this is what i am using
TextBox1.Value = Format(TextBox1.Value, "mmmm dd, yyyy")
But if the user puts in 041670 i get January 31, 2014.
what is the best way to handle this? I assume the solution is somewhere in forcing the user to type the date in the text box in a specific way. Since i am striving for consistancy. what is the best way to make sure they do this everytime. Or does the solutio lie elsewhere?