VBA works in all languages.(there is no "German" VBA.)

You must however ALWAYS keep regional settings in mind when you
write software. (. or , for decimal etc etc)

Your code can easily be tested on your english setup,
by simply changing Regional Settings.
(string to number conversions will be your main problem here
when you take numeric user input from text boxes .)

When your code adds formulas to a sheet, or manipulates Names
avoid FormulaLocal, always use Formula.
avoid RC, use A1 notations.
(and english function names, . for decimal and , for list separator)

When your code adds Dates use variables defined as Date.
(then READ/WRITE them to .Value2 property of cells.
Cell.Value2=cdbl(mydate)


Without seeing your code there is no general recipe...
Start with changing your regional settings to German.
adapt your code to take care of date and decimal stuff.

Then ask a foreign colleague to test. If some things still dont work,
isolate the problems and post back here with specific questions.

HTH


--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Colinhp wrote in


I work in a company with users in Germany, France and Spain. Their
computers would be set up for their native languages.
They can not open or use a tool I created in Excel which has macros
written in English. My computer is set up for UK use.
Is there additional code I should be writing for these users, that
converts English to their native language or are macros universal in
their behaviour? If the answer is yes, what is it I should be adding?
Many thanks.