The feature itself isn't that crazy – it's even a good thing, especially considering that Excel (and to lesser degree, VBA) were designed for ordinary people and that in the 80s/90s English was less common than it is today.

Where it went wrong is that as soon as you choose a language you were stuck with that. It should have been a display option.