Userform textbox date format

[melcoats]

I have a userform text box "txtInspect" and want it to only accept a date format mm/dd/yyyy and I want to let the user know that is the only format the text box will accept. I don't have 32bit, so datepicker is not available.

Any thoughts?

 

[NoSparks]

I don't have 32bit, so datepicker is not available.

Maybe have a look at this thread, then check out SamRad's site

 

[melcoats]

Hey NoSparks, had a look. Seems like this is for a worksheet, I'm looking for a solution in a userform. I have no idea if this works for both. Thanks.

 

[NoSparks]

I'm pretty sure that on the SamRad site when you scroll down to "DATE PICKER IN A USER FORM" it's for a userform.
There is a video there that tells you more than you really need to know and a file you can download and see it working.