Better VBA 1 - VBA Editor Settings

[@SimpleExcelVBA]

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

[@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

[@houstonvanhoy7767]

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.

[@codekabinettcomen]

Thank you for the comment. I tried numerous variations of dark mode in VBA and never had the cursor disappear. So, maybe it happens with some color combinations, but it is definitely possible to find dark mode settings that work well.

[@george27121984]

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.

[@bertjansen1041]

Phil, thank you for this video

[@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

[@codekabinettcomen]

I had to think about this for a while. If you compile the code ("Debug" menu), the compiler will point you to the line of the error. But you'll not get the "expected X instead of Y" part of the error message then. Unfortunately, I do not know any way to get this extended error information then.

[@lylebailey-sq2ek]

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

[@23myiah]

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?

[@dbdata9836]

thanks my n BAKR from egypt

[@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?

[@codekabinettcomen]

You mean You increase the font size in the editor settings and it has no effect? - I would try to open a support case with Microsoft to report this as a bug. Sorry, I've got no 4K display yet and cannot reproduce the issue.

[@codekabinettcomen]

Have you tried to increase the general Windows font scaling?

[@Esclarecidos]

@@codekabinettcomen Thanks! Yes, I tried increasing font scaling, but the font in the code area doesn't scale, for some reason. This is already an old issue, and Microsoft doesn't do nothing about it. When possible, try to reproduce the issue in a 4k monitor.

[@geomatrix5452]

Hi, I saw your post and have been adjusting mine, I'm using a 4K tv and I can change my font size up to 12, which is a good improvement. Would like to have a dark background but seems there are pieces ov white showing inbetween the text when I change forground and background...@@Esclarecidos

[@solruizdevargas1298]

Genial