Excel 2003, vb, form calendar date - set to todays date

Hi everyone...

Thanks to anyone in advance who can help me here.

Im designed a form in excel, which has a calendar date picker to select a desired delivery date for the user, which makes it easier to use for the user, than using a text box.

Ive searched a number of websites and so far havent seen what I need.

I want the calendar, once my form has been opened, to automatically change to the current date.

So in summary, the code, I believe would look something like this:

Sub Submit_Click()

Calandar2.value = date

//more code etc..

End sub

I seem to error with this...

Is there an alternative method? For some reason it always seems to only remember the previously used date.

Any help would be great.