I currently have a UserForm set up in an excel spreadsheet with multiple textboxes for inputting relevant data. One of these textboxes is used to input the date, I have set this up so you manually type in the date in the format dd/mm/yyyy however I have noted when I click the button and input all this data excel is automatically switching it so the numbers I put in for day and month get switched. So I input as dd/mm/yyyy and the way it is reading is mm/dd/yyyy.

I am looking for either another way to input the date rather than text or just a way to keep it as a textbox but stop the format from being flipped when I input. I don’t actually have any idea why this is happening so haven’t been able to try any fixes.

Form
Code