I am new to VBA and have tried to keep things simple.
I have a user form that extracts data from a "date" fields formatted in dd/mmm/yy, no matter what I try the data is extracted as mm/dd/yy. Therefor when I update the spreadsheet the wrong date is sent to my data table. It is totally corrupting my data table. The user forms are quite basic.