I activated a date picker in excel 2013 for use in my userform. The date picker defaults to the date that I added it, but I'd like to get it to default to today's date instead. I'm assuming that the issue is the value, but I'm unable to find an option that works in that field other than a specific date.
Capture1.JPG
It also gives an error when the user form is submitted, but it actually seems to be entering the date where I need it so I've just been ending it and ignoring it.
It shows this error:
Capture2.JPG
and relates it to this code:
Bookmarks