Hello All

I have created a command button which when clicked enters the date and time
into a textbox on my userform by using a sub - TextBox1.value=Now()

My problem is it enters in M/D/YYYY_H:M:S format and, being British, I
require D/M/YYYY_H:M:S format.

As I could not find a way of altering the date property of the text box I
attempted to add TextBox1.Format=D/M/Y_H:M:S into my sub but this only
created an error!

Could someone please advise on the correct method of acheiving what I
equire

TIA

Kenny