try:

TextBox1.Value = Format(Date,"dd-mm-yyyy")
or
TextBox1.Value = Format(Date,"dd.mm.yyyy")
or
TextBox1.Value = Format(Date,"dd/mm/yyyy")
or
TextBox1.Value = Format(Date,"dddd dd.mm/yyyy")
or ...


"Jan T." skrev:

I use Office2k and windows XP on two computers.

But, when I make a UserForm1 with a text box, my initialize procedure
set the TextBox1.Value = Date. However the result differ on the two PCs.

One UserForm shows US date format 10/2/2006. The other Computer has
exactly the same code but shows 02.10.2006 (e.i. October, the 2nd.,2006).

Know I want the european date format "dd.mm.yyyy". How can I achieve
this? Or what settings should I change?

Thanks in advance for helping!

Mvh
Jan.