Default date in Userform Calendar

In the attached file I have put together a userform that contains a drop down calendar in order for users to select relevant dates.

I have two questions:

1 - I've noticed that from creating the userform (04/01/10) the date has remained as this and not updated to the "current date". Is there any way this could be achieved?

2 - Is there any way the code etc. could be manipulated to alter the dates in the Date Entry boxes, based on that entered into the "Rostered Start Date" box.
I.e. If a user was to select 09/12/09 in the "Rostered Start Date" box, the other date boxes would automatically change to that date.

Thanking you all kindly,

Andy

One thing I noticed right away is that you use

HTML Code: 

for date and time.

Do you know you can use the same DATE type and display this as time or date?

Then your O/T calculation =((H4+I4)-(F4+G4))-((C4+D4)-(A4+B4)) would be easier.

Andy,

Can't work on it as some parts of your UserForm contains items that are not on my machine. Just installed XL 2010 which overrides my 2007 ( and I can't work on the Userform.

I've added code to your userform

As you can see from Ricardo's problem,the DatePicker & Calendar Control can be problematical on some computers. Check out the alternatives here under DatePicker

http://excel-it.com/vba_examples.htm

There is code that can be adapted to use with the ones you are using

If you can't let me know