Userform Textbox set to DD/MM/YY and changes to MM/DD/YY

Hi

I have a textbox with the code below on userform 1 & 2 showing the current date in DD/MM/YY, this date is copied from userform 1 to userform 2 and finally onto an excel worksheet. However, on some occasions the format changes to MM/DD/YY. Is there a way to force the date format to DD/MM/YY

Please Login or Register  to view this content.

As someone that develops userforms for a living, this little bug drives me barmy.
Format the date as "dd mmm yyyy" first then you should be able to change it again to "dd mm yyy" and it should work.

BSB

Hi BSB

Thanks, lets hope it solves the issue, looking good so far.