I have developed a userform that meets the needs it was designed for. However, I now find that all of the computers need to have this control activated though some are office 2013. I used the date picker as I was having trouble with using a text box for the date it would convert the date to mm/dd/yyy which fouled everything up. Is there an easy fix for the date textbox to use dd/mm/yyyy and copy that across to the workbook?