Userform placing date in spreadsheet as MM/DD/YYYY

[david1987]

Hi,

I have a spreadsheet which is set up for the UK date format, 'DD/MM/YYYY'. I have created a UserFrom to enter dates into the spreadsheet, however, when I enter the dates in the Userform they appear in the spreadsheet in a 'MM/DD/YYYY'. How can I change my UserForm code so that it places dates in my spreadsheet in the format of 'DD/MM/YYY' ?

For example, I enter '08/01/1987' in my userform, which is intended to be the 8th January 1987, but in my spreadsheet it is displayed as '01/08/1987', as in the 1st of August 1987.

The date boxes in my UserForm are 'TextBox4', 'TextBox12' and 'TextBox13'

Below is the code for my UserForm, everything else works perfectly:

Please Login or Register  to view this content.

[stojko89]

Try using

Please Login or Register  to view this content.

[david1987]

Thanks for that, it worked.

I have another UserForm in the same Workbook. This allows users to edit and view the data enterered in the spreadsheet.

However, it displays the dates in the wrong format similar to the way the Add Record UserForm did before.

Below is the code, could you suggest a similar fix? It would be greatly appreciated.

Please Login or Register  to view this content.

[david1987]

Found a resolution to this, thanks.

http://www.excelforum.com/excel-prog...html?p=2909635

Cheers