Google Translator Button.

I have a Workbook attached that have a google translate as Public Function using =JasonDTranslate(Range("A2"), "en", "ja")

A2 = have a english words that can translate into japanese using =JasonDTranslate(Range("A2"), "en", "ja").

My question is how to do a macro when I enter a english sentence or words in sheet 1 (any column of sheet 1) and click the button it will replace all the english words in sheet 1 to Japanase.

Thank you in advance.

Try this code in sheet 1 and assign your translate button to this routine.

Please Login or Register  to view this content.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

Thread closed as duplicate. OP has been warned before - infraction served.

@MarcL - please report these issues in the proper way, otherwise they may be missed and no action taken. If that happens, these people will just continue breaking the rules, wasting your time and ours.

Thanks.