Google Translate Macro Function - How to rafear to Cell and/or Text in Quotes?

[pacosalasv]

Hello experts, i modify actual script to create a function in Excel to translate from Google Translator with formula.

In order to work, you need to add Reference "Microsoft Internet Controls" (Tools>References)

I create it referring to a cell range value with syntax =GoogleTranslate(A1,”en”,”es”)

Is there a way to use, as well, Cell Range and/or Quoted Text? I mean, both with same formula function. I mean, use any of these two ways of syntax:

=GoogleTranslate(A1,”en”,”es”)

OR

=GoogleTranslate(“Specific Text in Quotes”,”en”,”es”)


Here is the VBA code for this function (Add as Module):

Please Login or Register  to view this content.

[Marc L]

Hi,

so just replace the Range parameter by a String …

[pacosalasv]

It Works! Thanks

Updated code, if some one needs.

Please Login or Register  to view this content.