Hi Everyone,
Is there any vba formula to restrict data input in a userform textbox.
I need to enter "MM/DD/YY" format value only, otherwise textbox will not accept the value.
Let me elaborate more, Numbers 01 to 12 should be allowed followed by "/" then numbers 01 to 31 should be allowed followed by "/" then any two digit numbers should be allowed to enter in text box otherwise a message should appear stating that "Invalid Date Format" .
Hope You guys understand my query.
Waiting for your suggestions.
Thanks
Is there any vba formula to restrict data input in a userform textbox.
I need to enter "MM/DD/YY" format value only, otherwise textbox will not accept the value.
Let me elaborate more, Numbers 01 to 12 should be allowed followed by "/" then numbers 01 to 31 should be allowed followed by "/" then any two digit numbers should be allowed to enter in text box otherwise a message should appear stating that "Invalid Date Format" .
Hope You guys understand my query.
Waiting for your suggestions.
Thanks