I have a userform which has a text box for the date (the date comes from the calendar control) it is formatted as "dd/mm/yyyy" (UK format) when the data is transferred onto the WS it converts it to US format mm/dd/yyy. The worksheet is formatted as UK - "dd/mm/yyyy"
Can anyone explain why it is converting it, and more so, how to rectify it?
Many thanks
Colin.
Can anyone explain why it is converting it, and more so, how to rectify it?
Many thanks
Colin.