自定义 VBA 编辑器
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/45520186/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Customize VBA editor
提问by Jean-FIC
I have been looking for a way to customize a bit the VBA editorof Excel. I found this nice githubpost : VBE Theme Color Editor.
我一直在寻找一种自定义VBA editorExcel 的方法。我发现了这个不错的github帖子：VBE 主题颜色编辑器。
Problem is, I cannot find the VBE7.DLLfile in my computer.
问题是，我VBE7.DLL在计算机中找不到该文件。
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"
对于 64 位：
“C:\Program Files\Common Files\microsoft shared\VBA\VBA7\VBE7.DLL”
对于 32 位：
“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?
有没有人尝试过这个软件（因此，可以帮助我解决它）或者有其他方法来自定义 VBA 编辑器？
I already tried the built-informat editor but colors are kind of ugly...
我已经尝试过built-in格式编辑器，但颜色有点难看......
Thanks for your help! :)
谢谢你的帮助！:)
采纳答案by Jean-FIC
In order to close this thread and help other users, @YowE3Khelped me find the VBE7.DLL file which was located here :
为了关闭此线程并帮助其他用户，@ YowE3K帮我找到了位于此处的 VBE7.DLL 文件：
C:\Program Files (x86)\Microsoft Office\root\VFS\ProgramFilesCommonX86\Microsoft Shared\VBA\VBA7.1
If not, try :
如果没有，请尝试：
- Open a cmd window (
Windows + R) - Type the following code
DIR C:\VBE*.DLL /Sand press enter
- 打开一个 cmd 窗口 (
Windows + R) DIR C:\VBE*.DLL /S输入以下代码并按回车
to find the path of your file. Again thank you to YowE3K!
找到你的文件的路径。再次感谢YowE3K！
My VBA editor now looks just the way I wanted :
我的 VBA 编辑器现在看起来就像我想要的那样：
