Default ActiveX Date Picker to todays

[I heart Excel]

Hello, Again,

Sorry to ask another question, spent all day yesterday trying to figure stuff out, but am really stuck on two things.

One is defaulting the ActiveX date picker to todays date when the document is open.

The second if whether you are able to sum the difference between ActiveX Time pickers?

Thanks very much

 

[I heart Excel]

Thanks, worked perfectly

 

[I heart Excel]

Hello,

I am now using a Text box for the date, as I don't want this being amended.

I have got the following to run once the form is opened -

Private Sub Workbook_Open()

Sheets("Annual Leave Form").TextBox1.Value = Date

The problem with this is that the Date is in US format and not UK dd/mm/yyyy.

I know I can set the format, but I am unsure where I need to put this.

Thanks in advance