VBU macro - English data entry coverts to American format

Hello

I'm wondering if you can aid.

I have created a macro workbook with a user entry form collecting key information. Of this key information, three fields are dates. These dates are copied into a database for further analysis and Macros. Currently this does not work as I intended as the dates are converting to a US format, e.g 01/06/2016 is converting to 06/01/2016. This does make a huge difference as I have a formulae to report on income deferred to another period and should the end date continue to be in the past, the report would not operate or inform the user of the correct accounting adjustment.

Currently the entry pastes as follows to my database

ActiveCell.Offset(0, 1).Select
ActiveCell.Value = TextBox4.Value
Selection.NumberFormat = "dd/mm/yyyy"


Many thanks
Michael

Hello Michael
Have you tried using Cdate in your code, for example:

Please Login or Register  to view this content.

This usually works for me with a UK region pc.

DBY

Many thanks - it works a dream