VBA and Excel are two different programs that have had very different upbringings. VBA speaks American. Excel also speaks American. However, Excel can also speak in its users' language if they have the appropriate Windows settings and Office language pack installed. On the other hand, VBA knows only a little about Windows settings, and even less about Office 2007 language packs. So, either you can do some awkward coding to teach VBA how to speak to Excel in the user's language, or you can just let them converse in American. I very much recommend the latter.
Unfortunately, most of the newer features in Excel are not multilingual. Some only speak American, and others only speak in the user's language. You can use the American-only features if you understand their limitations; the others are best avoided. All of them are documented later in the chapter.
Was this article helpful?