Excel User Form Date Stamp Problem

[alarmbloke]

Hi

I currently have a fully working user form in Excel Windows

I us the following to pre fill a hidden text box with todays date

txtDate.Value = Format(Date, "dd/mm/yyyy")

This then gets put in the first column of the spreadsheet row with other data

However this just doesn't work on the Mac version, no error just a blank value added.

What can i change the code to on the mac version??

Thanks