Problem with languages interfering with my work in Excel

[riddles70]

I am using a SPanish version of Windows. All the code I find in these forums is in ENglish but when I use it in my office applications its is being converted to spanish. Is there a way I can set the language in office?

 

[byundt]

riddles70,
VBA is always in English, no matter which language your Office application is using. Excel formulas, however, are translated into the local language (function names, separator & decimal characters, date formats).

Here is a useful tip by Microsoft Excel MVP Ture Magnusson for translating formulas:

http://www.experts-exchange.com/Applications/MS_Office/Excel/Q_21480349.html#14368365

You may also find Laurent Longre's translation of the function names to be useful:

http://cherbe.free.fr/traduc_fonctions_xl97.html

I put it into an Excel workbook here:

http://home.mchsi.com/~byundt/List_of_keywords_in_9_languages.xls

Brad