Of course this Translate() function can be used directly from VBA as well: MsgBox Translate([A1], “en”, “de”) ‘<–displays: Jeder Moment ist ein Neuanfang. Of course you may also manually use the Translate functionality built into Excel, which can be found on the Review tab of the Ribbon.
https://stackoverflow.com/questions/19098260/translate-text-using-vba

