Formelübersetzer EN >> DE

NikolinoDE
thank you indeed for your gesture, however uptodate in the topic eg. your link was/is my favourite but once have bumped into missing function names as Detlef_Lewin suggested too. and exactly this convinced me to do the ultimate tool. luckily i have finished last year my comprehensive learning file of "504 Excel functions" (in the meantime IMAGE, GROUPBY, PIVOTBY increased the length of that list btw). so i had to do only a language change/exit/start to get the native and most authentic local language version. after that had to figure out the most compact macro structure and decided in favour of arrays/matches however still some technicalities that needed solution:
--a vba macro line cannot be longer than 1000 characters, so had to break the usually 5 thousand characters of one array per direction
--functions had to be added to arrays in length decreasing order (this way you can avoid such situations as a COUNTIF is translated like COUNTWENN)
--making the first version in Hungarian realised to me that we have two characters "Ő" and "Ű" which cannot be displayed by the macro code directly so two functions had to be called for help (a funny thing re that having an abstract word combination to test all our special characters like "árvíztűrő tükörfúrógép" which stands for floodproof mirrordrill)

finally to demonstrate the greatest thing in using my macro (strictly via .xlam addin, which can be also practised this way), a fictional situation:
you are fighting with new solution ideas and jumping back and forth between 7 different project files and macro windows of course in English, since in some cases you have to rummage through forums as well for snippets. your German friend is calling you to start a share, where you should explain the latest solution you delivered but he/she cannot understand it in English, being only intermediate and knows all functions in German only. so...

...there you wont jump out from your opened 7 files after saving them (could take even 2-4 minutes not to mention that your creative flow is broken) just for showing everything in German, where i am not so fluent. rather take my macro and just select any previously copied cells in the newly opened 8th file and your presentation will be smooth, instantly understandable (as the translated formulas are calculating themselves automatically without copypasting anything from/to anywhere. and you know as soon as you learn that your previously favourite tool does not know one functiont-translation then trust is vanishing 🙂