如何在excel vba中将日期格式化为英国日期

I have created a userform which looks at several cells inputting dates. Strange that it is very temperamental when it formats the date as UK format. When I initially written the code it would format the date in UK format, and then again the next, today however the 11th September 2017 it has diverted to a US Format and instead of reading I have created a userform which looks at severa