tags:

views:

18

answers:

1

As anybody who uses VBA in Office 2003 will know, it has the extremely frustrating tendency to do a syntax check every time you click off a line.

For example, if I start writing a line of code, I might go

For Each application In

And then think "crap, what's the application collection called?" So I'll hit "page up" to find it, and get (in this case) a "Compile Error".

Can I turn this off?

+3  A: 

Yes.

Goto Tools-> Options and turn off 'Auto Syntax check'. While you're there, turn on 'Require variable declaration':

alt text

Mitch Wheat
Perfect! Now if only Ctrl+Y was "undo" instead of "delete line"...
ChristianLinnell