Is there any VBA Code to change VBA Editors background and Fonts Colors?

[Ashfaque]

Hi,

I wish if there is VBA module that could change VBA editors theme to set back color and font color.

Is there?

 

[conception_native_0123]

i don't think there is. and the reason why is because the VBA editor is a different entity than the modules. the modules are connected to the VBA editor by way of being houses for code. the editor runs on the menus and toolbars at the top.

 

[arnelgp]

goto VBA.
on menu, Tools->Options->Editor Format.
you can change the background color and the font color and everything.

 

[The_Doc_Man]

NOTE that if you also have Excel VBA code (for example), changes made from Access may have a similar effect with Excel. We had a thread about this kind of unexpected changes several years ago, while I was still working. (I retired in 2016, so at LEAST five years ago.)

As Adam has noted, the VBA editing environment is shared by all of Office. So one change affects all VBA environments.

 

[The_Doc_Man]

Found this thread that mentions the fact that VBA settings are in the registry under Office, not under Access or Excel. So that confirms "one VBA environment fits all." It's newer than I thought but I think I knew the answer in that thread because of a prior thread.

Can't change font size in VBA Code Editor in MS Access 2016

I am using Access 2016 on a laptop with an UHD screen (it's an ASUS N552VW model). I can change the font, but not its size. When I open Tools\Options, then the Editor Format tab I can change the value in the Font combobox, but any change in the Size combo is not saved and applied. Does any body...

www.access-programmers.co.uk

 

[Ashfaque]

goto VBA.
on menu, Tools->Options->Editor Format.
you can change the background color and the font color and everything.

Thanks Arnel,

This I know. But I was looking for module.

Anyway, Thanks.

 

[Ashfaque]

NOTE that if you also have Excel VBA code (for example), changes made from Access may have a similar effect with Excel. We had a thread about this kind of unexpected changes several years ago, while I was still working. (I retired in 2016, so at LEAST five years ago.)

As Adam has noted, the VBA editing environment is shared by all of Office. So one change affects all VBA environments.

Yes you are correct, when we change background and fonts color in Access VBA, it affects in Excel too...