How to set date picker default date to Today()?

I am talking about Date Picker in userform, and it works fine. But the issue is: every time when opening the form, the default value is the value in the property. Typically, it is the date I created the control. Of course the date can be changed to another date(such as 11/23/2017). But that is not what I want, I wanna change it to a dynamic date (the date when opening the form).

I tried to enter today() there, but it could not be accepted. Syntax is wrong, I guess.

Thanks.

It has been years since I used the Date Picker control but as far as I can remember, all you need to do is in the UserForm Initialize event, set the Date Picker's Value to Date...

dtPicker1.Value = Date

Originally Posted by Rick Rothstein

It has been years since I used the Date Picker control but as far as I can remember, all you need to do is in the UserForm Initialize event, set the Date Picker's Value to Date...

dtPicker1.Value = Date

Thank you.