So there I was, trying to find best color combination for making my VBA editor in dark theme. While I did find an open source utility on GitHub to hack the VBE.dll and then replace it in the system, I simply wanted to know a color combination that I can quickly set in the built in VBA color palette editor so that I can make the editor dark.
So I made this guide for myself to do just that, a quick 2 min will give you dark theme!
To set these, in the VBA editor, goto Tools -> Options -> Editor Format. Then refer below table to set the colors.
Now set the colors to below:
|Comment Text||Dark Grey||Black|
|Keyword Text||Light Green||Black|
|Identifier Text||Sky Blue||Black|
|Bookmark Text||Dark Green||Black|
|Call Return Text||Blue||Black|
And there, in 2 min now your VBA editor looks something like below. You can tweak it to your liking.