I have UserForm3 that has a single box for the user to enter the
date. I would like this box to have the current date in there by
default, and the user can change it if needed.

When the user clicks the OK button, this date will be copied to a range
named Current_Date. I've already designed the form, with a text box,
and the OK button. I know how to get the input to Current_Date once the
user clicks OK. But, I need the default date to show up in the box when
it comes up.

I looked around in the text box properties, and didn't see where I
could set this up. Would code be written in a sub within UserForm3 to
handle this?

Also, I want to make sure the format of the date that would be entered
in the text box can only be mm/dd/yy.

As always, I appreciate any help anyone can offer.

J.O.