Customize VBA editor

Question

I have been looking for a way to customize a bit the VBA editor of Excel. I found this nice github post : VBE Theme Color Editor.

Problem is, I cannot find the VBE7.DLL file in my computer.

It should be located at:

• For 64 bit:

  "C:\Program Files\Common Files\microsoft shared\VBA\VBA7\VBE7.DLL"

• For 32 bit:

  "C:\Program Files( x86)\Common Files\microsoft shared\VBA\VBA7\VBE7.DLL"

Has anyone tried this software (and therefore, can help me out with it) or has an alternative way to customize the VBA editor?

I already tried the built-in format editor but colors are kind of ugly...

Thanks for your help! :)

Answer 1

In order to close this thread and help other users, @YowE3K helped me find the VBE7.DLL file which was located here :

  C:\Program Files (x86)\Microsoft Office\root\VFS\ProgramFilesCommonX86\Microsoft Shared\VBA\VBA7.1

If not, try :

1. Open a cmd window (Windows + R)
2. Type the following code DIR C:\VBE*.DLL /S and press enter

to find the path of your file. Again thank you to YowE3K !

My VBA editor now looks just the way I wanted :