Changing language of Visual Basic Editor to English

Question

After Microsoft Office updated to the 2016 version I found the VBA interface is in German. How can I restore it to English?

My Windows 10 settings are set to English and the local setting preferences are all for English UK as well (dates, decimals etc.).

I set the Office Preference Language to English.

Answer 1

Have a look at the setting at Control Panel > Region and Language > Administrative. If it's showing "Germany/German" for non-unicode programs, you might be able to change it there.

---

This thread at answers.microsoft.com suggests to have a look at the folder C:\Program Files\Common Files\microsoft shared\VBA\VBA7.1.

Hello, I've had the same problem and finally found the solution. The language file for VBA editor interface is stored in the following folder with different subfolders:

C:\Program Files\Common Files\microsoft shared\VBA\VBA7.1

(you may need to search for VBEUIINTL.dll if you can't find this folder on your computer)

in this folder the 1033 subfolder and its contents are for English interface. The other ones are for different languages. Somehow VBA chooses the wrong subfolder. So you basically need to copy the contents of 1033 folder ( as a workaround ):

"C:\Program Files\Common Files\microsoft shared\VBA\VBA7.1\1033\APC71ITL.DLL"
"C:\Program Files\Common Files\microsoft shared\VBA\VBA7.1\1033\VBE7INTL.DLL"
"C:\Program Files\Common Files\microsoft shared\VBA\VBA7.1\1033\VBEUIINTL.DLL"

to the 2052 folder (for chinese for example, may be you have different), for changing the language.

Before doing this , restart and don't start any office products. Then copy the files; overwrite if asked. I also suggest you to take a backup of VBA7.1 folder in case something goes wrong.

The suggestion to restart seems a bit unneeded to me - just make sure all office programs that support VBA (Excel, Word, Access, PowerPoint, Outlook) are closed.

Also this latter method seems more like treating the symptoms - to me it doesn't appear to be the correct way of changing the language of your VBE (merely one suboptimal way).