Hi all,

I have a userform with a textbox where a user will input the date. As I am
from Australia, the standard format would be dd/mm/yy. This works ok until I
click the OK button and the data is transferred to the worksheet as
mm/dd/yy.

Can someone tell me if I will need to insert a line of coding in the
userform to convert the date to dd/mm/yy and then transferred to the
worksheet as dd/mm/yy instead of mm/dd/yy.

Thanx in advance.