Hi everyone, I have searched for help in many forums etc and all look and sound right but none are working for me.
As you can see my Spreadsheet is in dd/mm/yy but as my userform reads the data it changed it to mm/dd/yy and i set a msgbox to show also incase the value of the item changed again. I can get it to right the data as dd/mm/yy but when i then go back in again the spreadsheet is correct at dd/mm/yy but the userform again reads it as mm/dd/yy and i must again manually change it even if i dont need to edit that field.
Thats the code for pulling up the form to show what is already in the sheet, except it chaged to mm/dd/yy. Also my local settings are all as Australian, and set to local - *dd/mm/yy settings.
Does anyone have some suggestions. This is just a play with file to get the dates working as all of the rest of the real sheet is fine and doesnt do anything to the dates anyway. So this sample will be all i need to get right to then put it in my larger file code.
Thanks
As you can see my Spreadsheet is in dd/mm/yy but as my userform reads the data it changed it to mm/dd/yy and i set a msgbox to show also incase the value of the item changed again. I can get it to right the data as dd/mm/yy but when i then go back in again the spreadsheet is correct at dd/mm/yy but the userform again reads it as mm/dd/yy and i must again manually change it even if i dont need to edit that field.
Thats the code for pulling up the form to show what is already in the sheet, except it chaged to mm/dd/yy. Also my local settings are all as Australian, and set to local - *dd/mm/yy settings.
Does anyone have some suggestions. This is just a play with file to get the dates working as all of the rest of the real sheet is fine and doesnt do anything to the dates anyway. So this sample will be all i need to get right to then put it in my larger file code.
Thanks