How to get more helpful error messages?

Hi - I've found that when coding in Excel VBA I get annoying, useless error messages but never useful error messages.

If I type half of a line of code, then change lines (ie maybe to copy a variable name from one place to the line I'm working on) - I get an error message. I find that to be pretty unhelpful and just annoying. It means that I often comment out lines of code I'm working on and then uncomment them when I'm finished. Is there a better workaround?

But my real issue is that when I do have an error in my code, I don't get warned at all. For example, I just tracked down a problem in my code where I was doing something like

Foo = 1
Bar = 2
Foobar = Fooz + Bar

In this example, Fooz was never declared but the code executes without warning, and just treats Fooz as 0. Can I get a warning on situations like that? Similarly, I've had problems with functions that were not accessible just getting a 0 value.

Are you getting errors while you are writing the code?

If you are you can turn that off by going to Tools>Options... and unchecking Auto Syntax Check on the General Tab.

To be warned about undeclared variables you can add Option Explicit at the top of the module.

You can have that appear automatically if you goto Tools>Options... and checking Require Variable Declaration.