Maybe you could have the user type the date in an unambiguous format:
October 2, 2006
(so it'll be clear to both your code and the user)

or use a calendar control...

Ron de Bruin has some tips/links at:
http://www.rondebruin.nl/calendar.htm

"Jan T." wrote:

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.

--

Dave Peterson