I'm developing an Excel User form which holds a few text boxes, some function buttons and a Listbox to manage records on a worksheet called 'Orders'.
The problem is this : when I update a record in my User form, the Order date in the textbox and also in the Listbox changes from dd/mm/yyyy to mm/dd/yyyy.
It also changes the format of the date on the underlying data sheet in the same way. I've tried reformatting the date just before I commit the update but it doesn't seem to make any difference.
Can anyone please help ?
I've attached a cutdown version (in data at least) of the application.