The menus and sidebar are still the default colors of white and grey, unfortunately. I have a long list of modules, so I need a long big sidebar that is a big white area on the screen :(. The Office dark theme can make the Access application window all dark including the menus and everything. Yet the VBA editor, which many of us use a lot, is not affected by the Office theme. In Visual Studio, however, the VBA editor does get the dark theme. It is little things like this (and other issues) that turn people away from Access.
There's a tool called VBAThemeColorEditor on github that allows to achieve much better dark themes by redefining the colors in the vbe7.dll file. However, it is nearly useless since MSO updates every other minute, and the settings are lost every time... Until the author adds some "auto-recover dark theme after update" functionality, it's a real hassle. In any case, the side windows such as project explorer are not themed, so continue to burn out the eyes in dark conditions.
Hey, there is something called VBEThemeColorEditor. If you search on Stackoverflow for "Customize VBA Editor" or google it, you will get a tutorial on Changing your Colors in VBA so that you have similar Colors as on Visual Studio. Maybe this is helping someone 👍
Thanks Kolavit for your contribution to the post. This tut is to show how it can be done without external plugin/software. The outcome is the same though you have to manually set it without software.
Brasileiro aqui? haha, boa. Uma pequena correção, você deveria dizer "Thanks from Brazil". Mas seu inglês é bom, só um errinho pequeno ^-^ Gosto de ver br's na comunidade estrangeira, principalmente em programação. Bora pra cima!!
Please do not forget to subscribe and support us. :) thanks! // WHAT TO WATCH NEXT PDF Automation using VBA: bit.ly/37FZNsS Sharepoint Automation Using VBA: bit.ly/2ZUlwuG Access Database Automation using Excel VBA: bit.ly/2FnOvgV SQL Server Automation Using VBA: bit.ly/2QrJdat Plug and Play Series: bit.ly/39Io6bN Office Quick Tips: bit.ly/36rZX75
I love this settings, the white screen produce eye strain the only thing is I downloaded the Source Code Pro but where do I have to install this to be able to used? Thanks, you are a genius man.
thank you. it's a huge luck that i found this video, i'm only 40 hours into vba programming, so this will save my eyes
Glad to hear that!
i use the font : calibri light, size 11.
This is because i make long codes, so i need to see as much as possible without scrolling (to debug).
wider view definitely helps.
You mention taking a back up before changing colours in the editor - how do you take a back up and then restore if necessary?
Just started viewing some of your videos and it certainly helps to start with some of the basics. So much easier to see my code.
Thanks!
Excellent - especially the font. Much easier on the eyes
The menus and sidebar are still the default colors of white and grey, unfortunately. I have a long list of modules, so I need a long big sidebar that is a big white area on the screen :(. The Office dark theme can make the Access application window all dark including the menus and everything. Yet the VBA editor, which many of us use a lot, is not affected by the Office theme. In Visual Studio, however, the VBA editor does get the dark theme. It is little things like this (and other issues) that turn people away from Access.
I hear you...
You're brilliant bro. Learn many new things from you. Keep up the good work and contribution to community. Stay Blessed!
thanks for your kind words.
This is great! Has anyone found a way to change the text cursor within the application so that it contrasts with the black background?
not that I'm aware of
Brilliant tutorial. This gonna save lot of stress to eye
glad to hear that
Thank you so much. Is there a way to add more colors?
I mean the font color
Not that I know of
There's a tool called VBAThemeColorEditor on github that allows to achieve much better dark themes by redefining the colors in the vbe7.dll file. However, it is nearly useless since MSO updates every other minute, and the settings are lost every time... Until the author adds some "auto-recover dark theme after update" functionality, it's a real hassle.
In any case, the side windows such as project explorer are not themed, so continue to burn out the eyes in dark conditions.
Hey Mark, thanks for sharing .
Thanks for sharing this very useful customisation i haven't seen before. 👍👍👍
Thanks. I love this customization it looks like new IDE.
Hey,
there is something called VBEThemeColorEditor. If you search on Stackoverflow for "Customize VBA Editor" or google it, you will get a tutorial on Changing your Colors in VBA so that you have similar Colors as on Visual Studio.
Maybe this is helping someone 👍
Thanks Kolavit for your contribution to the post. This tut is to show how it can be done without external plugin/software. The outcome is the same though you have to manually set it without software.
Can I use my own photo in my editor as a background theme?
I'm afraid no
Simple solution and great result!
Thank you! Cheers!
From Nigeria say happy new year 2021
Happy new Year!
Font size doesn't change when using a 4k monitor! It stays at 8 or 9 point at maximum. Any sugestions?
The universe blesse you, man!
Thanks for the Brazil, you help me a lot!
This will help my eyes e my work.
Thank youuuu!
Glad to hear that! bless you too
Brasileiro aqui? haha, boa.
Uma pequena correção, você deveria dizer "Thanks from Brazil". Mas seu inglês é bom, só um errinho pequeno ^-^
Gosto de ver br's na comunidade estrangeira, principalmente em programação. Bora pra cima!!
Why my text (only those are VBA function, classes like If, Else, or variable) automatically turn into white background, no matter option I chose?
customize the selection background from VBE options
this is excellent. never knew we could do that.
thanks!
Is it possible to change Workbook Color Office Theme (Options/General/Personalizeyour copy of Microsoft Office/Office Theme) via VBA code?
I have not tried it myself however it looks like there isn't a direct VBA method to change the overall Office Theme setting through code
and there i thought there is a way using vba to do it. A bit disapointed , but only ecause i knew how to do it manualy already.
if you're comfortable with registry edit we can export / import check below link
th-cam.com/video/zm_5YAngxIQ/w-d-xo.html
Please do not forget to subscribe and support us.
:) thanks!
// WHAT TO WATCH NEXT
PDF Automation using VBA: bit.ly/37FZNsS
Sharepoint Automation Using VBA: bit.ly/2ZUlwuG
Access Database Automation using Excel VBA: bit.ly/2FnOvgV
SQL Server Automation Using VBA: bit.ly/2QrJdat
Plug and Play Series: bit.ly/39Io6bN
Office Quick Tips: bit.ly/36rZX75
Thank you. This is nice 👍
Welcome 😊
Absolutely loved it!!! Thanks
Thank you! ☺️
You’re welcome 😊
Nice work! Can you export the settings to be able to use them on another device, or do you need to configure it each time?
Yes you can. please check this video.
th-cam.com/video/zm_5YAngxIQ/w-d-xo.html
Looks very cool 😎
Xbr10 Sir💜💜💜
thanks!
I love this settings, the white screen produce eye strain the only thing is I downloaded the Source Code Pro but where do I have to install this to be able to used? Thanks, you are a genius man.
simple open the font file, you'll see install button in top left , click on it and that's it.
Restart your excel and you should be the font.
Thank you it was very helpful my friend
Glad it helped
No mean to modify the ribbon's color ?
that's right
Thank you that is amazing now !
Can we change the VBA window too ?
no we cannot, we can only customize it.
You might be interested in VSTO
th-cam.com/play/PLo0aMPtFIFDqaRyd0KZ0DLXFD3rfhI4SU.html
Thank you brother! This is excellent!
You are very welcome
Is anyone have the default colour code, forgot to save the default one.......
Here is how to reset, backup, restore etc.
th-cam.com/video/zm_5YAngxIQ/w-d-xo.html
@@VBAA2Z thank you bro
@@wenhaochang6189 you're welcome bro!
Thank you Sir, my eyes are really happy!
Most welcome!
Liked! Thanks
Thanks for the visit
Thank you, very cool.
Glad you liked it! thanks for watching.
Brilliant 👍👍👍
thanks
You’re awesome thanks 🥇
thank you!!!
You're welcome!
Thank you it's very usefull
Glad to hear that
Thank you.
You're welcome!
Thanks for your video, in my PC unable to Find source Code Pro(west) Fonts..:-(
Please find the link to download the font from video description.
@Murat Bozlağan
Simply install the font, select the font from VBE Options
vbaa2z.blogspot.com/2020/04/how-to-customize-vba-editor-to-dark.html
💛💛💛 thanks sir
Thanks!
Welcome!
This is great
thanks!
Thank you so much
You're most welcome
Awesome, thx!
thanks Victor. Please subscribe for upcoming videos.
regards.
@@VBAA2Z yeah! Done.
Very useful
thanks
excellent!
awesome!
thanks!
thank you
you're most welcome!
14K coders viewed this!
:) thanks!
Thanks
You're welcome. Thanks for your support.