A function that crashes: Compile Error: Procedure too large

[Magic_Doctor]

Hello,

Now it works!

The function, which started out as a single piece, worked very well in any case, as long as you did not exceed 184 languages ​​(which is already a lot!). Beyond that it didn't work strangely anymore. So I had to split the function into 3 parts (2 parts with a maximum of 150 languages ​​and a part that manages everything), which was not very difficult (the difficulty, or rather the puzzle, was elsewhere…). This allowed me to expand the list of languages ​​without any problem.
The project was, after all, simple: to create a function which returns only the name of the day of the week in a language chosen in this same function. All the data is in the function (there is nothing on a sheet - hidden or not - of the workbook):
- the list of days of the week in different languages, whatever their alphabet;
- the list of transcribed languages ​​(latinized) when the chosen language is in an esoteric alphabet;
- the list of the days of the week in understandable reference languages ​​to have the translation of the names of the days of the week in the other languages ​​completely incomprehensible most of the time.
In a ComboBox of the form are listed all the languages ​​listed in the function (in fact, the 2 functions that contain them). You choose a language from the list, and in an individual cell (under that of the date) the name of the day of the week in the chosen language appears. If the chosen language is in an incomprehensible alphabet (Russian or Armenian for example) and that in the function there is its Latinized transcription, then appears in a cell, just below the one with the name of the incomprehensible day of the week, this same latinized transcription; which is particularly helpful in trying to decipher and pronounce (as much as possible…) the name of the day of the week. Indeed, when you do not know Russian, Korean or Hebrew, good luck deciphering! Finally, if desired, we can display, in a separate cell, the translation of the day of the week in a reference language (chosen in a dedicated ComboBox of the form) that we understand.
Note that wherever you can click (obviously to trigger something) the RollOver symbol appears (hand with an outstretched finger).
The password is "zaza".

Mr SamT, thanks to your invaluable encouragement, you energized me, and now I can say "la vie est belle !"