Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How to translate functions
Best of Excel
From English to my language
Write the function in a cell as you would have written it in the English version (Ignore the error message). Select that cell and run the macro above. This automatically converts the non-working English function in the cell to a working local one, if there is a function within the cell. Otherwise, nothing happends.
Note that the sub works an a multiple selection (array) as well!
From my language to English
This only shows the translation in a messagebox, since you probably won't have much use of it if it would write over the original, working function...
Enjoy!
Code:
Sub Translate_function_from_English()
Selection.Formula = Selection.Formula
End SubWrite the function in a cell as you would have written it in the English version (Ignore the error message). Select that cell and run the macro above. This automatically converts the non-working English function in the cell to a working local one, if there is a function within the cell. Otherwise, nothing happends.
Note that the sub works an a multiple selection (array) as well!
From my language to English
Code:
Sub Translate_function_to_English()
MsgBox Selection.Formula
End SubThis only shows the translation in a messagebox, since you probably won't have much use of it if it would write over the original, working function...
Enjoy!