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
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.
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.
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!
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
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.
From Nigeria say happy new year 2021
Happy new Year!
Thanks for sharing this very useful customisation i haven't seen before. 👍👍👍
Simple solution and great result!
Thank you! Cheers!
Brilliant tutorial. This gonna save lot of stress to eye
glad to hear that
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!!
Thanks. I love this customization it looks like new IDE.
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
You mention taking a back up before changing colours in the editor - how do you take a back up and then restore if necessary?
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.
this is excellent. never knew we could do that.
thanks!
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.
Absolutely loved it!!! Thanks
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...
Liked! Thanks
Thanks for the visit
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 .
thank you!!!
You're welcome!
Thank you! ☺️
You’re welcome 😊
Thank you Sir, my eyes are really happy!
Most welcome!
Thank you, very cool.
Glad you liked it! thanks for watching.
Xbr10 Sir💜💜💜
thanks!
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.
ruclips.net/video/zm_5YAngxIQ/видео.html
Thank you brother! This is excellent!
You are very welcome
Thanks!
Welcome!
Thank you. This is nice 👍
Welcome 😊
Looks very cool 😎
Thank you.
You're welcome!
Thank you it was very helpful my friend
Glad it helped
Font size doesn't change when using a 4k monitor! It stays at 8 or 9 point at maximum. Any sugestions?
Thank you so much. Is there a way to add more colors?
I mean the font color
Not that I know of
This is great
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.
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
You’re awesome thanks 🥇
awesome!
thanks!
Awesome, thx!
thanks Victor. Please subscribe for upcoming videos.
regards.
@@VBAA2Z yeah! Done.
Can I use my own photo in my editor as a background theme?
I'm afraid no
excellent!
Thank you it's very usefull
Glad to hear that
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
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
ruclips.net/p/PLo0aMPtFIFDqaRyd0KZ0DLXFD3rfhI4SU
Brilliant 👍👍👍
thanks
💛💛💛 thanks sir
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
Thank you so much
You're most welcome
Very useful
thanks
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
ruclips.net/video/zm_5YAngxIQ/видео.html
thank you
you're most 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
You're welcome. Thanks for your support.
No mean to modify the ribbon's color ?
that's right
14K coders viewed this!
:) thanks!
Is anyone have the default colour code, forgot to save the default one.......
Here is how to reset, backup, restore etc.
ruclips.net/video/zm_5YAngxIQ/видео.html
@@VBAA2Z thank you bro
@@wenhaochang6189 you're welcome bro!