DatePickers and userforms

[PMRetired2012]

I have a userform that i used the multipage tool that has that has 5 tabs. in those 5 tabs i have 5 datepickers. what i want to do is write code on the form initialization part (or where ever it needs to go) of the code to where the current date shows up in datepicker on each tab. im not how to get all those datepickers to default to the current date. If i need to put in some code let me know what it is and how to put into the ionization code if that is where it goes or if i can do that from the properties of that particular datepicker
Just a side note if i couldnt get default datepicker to work would it be possible to ge the datepicker to allow me to insert the current date?

Dennis

 

[sykes]

Untested, and a bit "schooolboy" but...

NB test on a COPY of your work first:

Private Sub UserForm_Initialize()
Me.DTPicker1.Value = Date()
Me.DTPicker2.Value = Date()
Me.DTPicker3.Value = Date()
End Sub

etc...
Obviously, change the names of your datepickers, to suite.

 

[PMRetired2012]

Untested, and a bit "schooolboy" but...

NB test on a COPY of your work first:

Private Sub UserForm_Initialize()
Me.DTPicker1.Value = Date()
Me.DTPicker2.Value = Date()
Me.DTPicker3.Value = Date()
End Sub

etc...
Obviously, change the names of your datepickers, to suite.

This didnt work out for some reason

 

[sykes]

Please say WHY it "didn't work out."
you need to explain where you put the code, and what actually happened when you ran it; did it error, in which case, what was the error code/message?
Did it run, but nothing happened?
Did it run, but something undesirable happened? ...