Better VBA 1 - VBA Editor Settings

Configuration settings of the VBA Editor you absolutely must know and adjust, before you write the very first line of code!

[SimpleExcelVBA]

This is something what every VBA beginner should know first! :)

[houstonvanhoy]

I haven't seen anyone recommend even looking at the menu settings that you explain here. Thank you.

You didn't mention this detail, Phillip, but under Tools Options Editor Format, I noticed that I could change my bright white standard coding screen to dark mode by selecting Foreground white and Background black. Your eyes will thank you. 👀👀

Another viewer - @23myiah - reports that the cursor disappears when he does this. I haven't gotten to that point yet.

[LearnAccessByCrystal]

Excellent overview of the editor and great suggestions! I didn't know about turning off Auto Syntax Check ... nice! I also turn off Compile On Demand to reduce chance of corruption, which means you must remember to compile each time you make a change. Thanks, Phillip

[george]

Break in class module you can use it if an error coming from a custom class. But if en error coming from a class that exist in a dll may cause problems. Thats why hou have the option.

[XxparrotBobxX]

Phil, thank you for this video. I agree with you, the Auto Syntax Check is very annoying. However, sometimes, I run into trouble with knowing what the error is. The editor highlights the line where the error is but sometimes I'm forced to turn the Auto Syntax Check back on to see what I'm missing. Any suggestions? I wonder if it's possible to print the error message to the immediate window. Something along the lines of ?Err.Number or ?Err.Text

[myiah]

Hi, I have tried to set the editor to a dark background and a light text but when I do so the cursor disappears, any ideas?

[lylebailey-sqek]

ok know how do you get rid of the white backgroound?

[Esclarecidos]

Editor's font size doesn't change when using a 4k monitor (like many TVs). This is a HUGE problem a lot of people are facing. Any suggestions?