Multiple DTpicker's to display default date as today?

[chrismccarthy17]

SO I have a userform that has 4 DTPicker's on it, when ever I open the userform the DTPicker's show a date from last week?! How do I get them to show the current date when they're opened?

Below is all the code I have in regards to the userform

Please Login or Register  to view this content.

Below is the macro button used to open the userform

Please Login or Register  to view this content.

Any help would be appreciated as this has me baffled now!

thanks

[AlphaFrog]

Add this procedure. It sets the DTPicker dates to today's date when the userform is initialized.

Please Login or Register  to view this content.

[chrismccarthy17]

Add this procedure. It sets the DTPicker dates to today's date when the userform is initialized.

Please Login or Register  to view this content.

Thanks, were do I add this? To the Macro that opens the userform or the in amongst the code in the userform?

[AlphaFrog]

In amongst the code in the userform. That's the userform's code module.

[chrismccarthy17]

Thanks. Works perfect