×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Microsoft: Office FAQ

Best of Excel

How to translate functions by 01Patrik
Posted: 10 Sep 04

From English to my language


CODE


Sub Translate_function_from_English()

Selection.Formula = Selection.Formula

End Sub

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

CODE


Sub Translate_function_to_English()

MsgBox Selection.Formula

End Sub

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!


Back to Microsoft: Office FAQ Index
Back to Microsoft: Office Forum

My Archive

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close