I have a Userform and 2 text boxes that require users to enter a date. I really need the users to be forced to enter the date in "mm/dd/yy" format or they cannot get passed that text box or at least an error comes up.
thanks for the tips
I have a Userform and 2 text boxes that require users to enter a date. I really need the users to be forced to enter the date in "mm/dd/yy" format or they cannot get passed that text box or at least an error comes up.
thanks for the tips
You can check if the user has entered a date, in any valid format, using IsDate, then you can use Format to convert it to the specific format you require.
Please Login or Register to view this content.
Last edited by Norie; 06-12-2014 at 10:53 AM.
If posting code please use code tags, see here.
perfect. thanks a lot
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks