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.