Excel translate function with vba

Occasional Visitor

Hello, in excel is a translation function included. I need a vba code like:
Got to A1 (english) translate it to spanish and write it to B1, next line. Stop after 5000 lines.


Is anyone able to create a solution for it?


Thanks for help!


1 Reply


Excel Functions Translator

This article will walk you through setting up and using the Excel Functions Translator add-in. The Functions Translator is geared towards people who use versions of Excel in different languages, and need help finding the right function in the right language, or even translating entire formulas from one language to another.


EXCEL Translator

none Microsoft site

The following online tool allows you to translate an Excel formula from one language into another language and therefore use the localized formula.


Hope I was able to help you with this info.



I know I don't know anything (Socrates)