Converting Date To American Format 1

[SgtPepps]

I have a cell with the date In Day/Month/Year format but when its transferred to a userform:

Userform.TextBox.Value = Activecell.Value

It converts the date to Month/Day/Year. How can I stop this?

Regards

Sgtpepps

 

[Loomah]

Hello Sarge
try this to reformat

UserForm1.TextBox1.Value = Format(Sheets(1).[a1].Value, "dd/mm/yyyy&quot

;-)

 

[SgtPepps]

Excellent cheers!