Setting language

[Cor van der Bliek]

How do you change language during execution of a UserForm.
I want the result of a Date statement to be in English, but keep getting
Dutch results. No doubt this is a result of the Application language, but the
docuement is set to English VS.

Me.Controls("Textbox8").Text = Format(Date, "Mmmm, d yyyy")

 

[Doug Robbins]

You could always use

Format(Date, "MMMM") & ", " & Format(Date, "d") & " " & Format(Date, "yyyy")



--
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP

 

[Cor van der Bliek]

This is no solution. I want the date to show in English in the form:
January, 15 2005.
That's the normal format in English, isn't it?

 

[Doug Robbins]

No, that's not any normal format that I am aware of.

English would be 15 January 2005, maybe with a comma after the month, but
not always.
American would be January 15, 2005

Apart from in your post, I have never seen January, 15 2005.

--
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP

 

[Klaus Linke]

And if you need to show the date in a language format that's different from your
regional settings, then this thread (using date fields in the document or string
replacements) might help:
http://groups.google.com/[email protected]

Regards,
Klaus