Update Date Picker in userform automaticaly

Hi,
Hope that all of you are doing well.
I hope you can help me in this matter. I have put a date picker in a userform with a update button next to it. As soon as the update button is pressed, the specific date chosen must go to Sheet 1 (A1). I managed to do it, but I would like to change it a bit, i want to remove the update button, which means I want it to update without pressing the update button, is it possible? And secondly i want it to show always today`s date when I open it? Can anyone please help me in this matter.
Thank you and kind regards

Hello Nicholas1978, and welcome to the forum.

Please note that this area is only to introduce yourself and is not the right place to post questions. I see that you have posted your question in the Excel Programming area. http://www.excelforum.com/excel-prog...omaticaly.html That would be the appropriate place and I'm sure you'll receive a solution shortly.

Enjoy your membership in the forum