ExcelBanter - Switch between Languagges

With VBA you can (and should) write to the (standard)
USenglish properties like Formula and FormulaR1C1.

You could also write to FormulaLOCAL and FormulaR1C1Local
and use things like AddressLocal.. but I STRONGLY advise against it.
as you'd need to code for all possible languages

You might want to read this article on MSDN..

Writing Code for International Use
http://msdn.microsoft.com/library/de...l=/library/en-
us/dno97ta/html/msdn_intlcode.asp

In a multilanguage Excel setup (with multiple language for menu's
and help) you HAVE to use the Office Language Selector to change
those settings, and Excel must be restarted in order to reinitialize
itself with the proper localized DLL's

In case you mean the spelling options and language settings (as you can
change with WindowsXP language bar...

see:
Range Object
.CheckSpelling (range object)

Application object
.SpellingOptions
.DictLang = 1036
.UserDict = "CUSTOM.DIC"

'Thse apply to installs.. (see above)
.LanguageID (READONLY)
.LanguageSettings
.LanguagePreferredForEditing(msoLanguageIDEnglishU S)

keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool

helmekki wrote:

Hi

Is there a code to switch between Languagges ?

that is used to write within Excel sheet

Thank u :rolleyes: