Compile Project?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I've seen enough people include "Compile your VBA project" as an important
step in development. Intutitively, it seems a good idea.

But why? Does it help fend off corruption? Improve performance? I'm just
curious. Thanks.
 
It also can catch syntax errors in your VBA code.

AND if you have not declared a variable and have variable declaration set to
required (Option Explicit) then you'll get a warning.

I won't tell you how many times I've misspelled a variable name and have had the
compile tell me it cannot find the variable declaration. So my code doesn't
bomb out when it runs into an undeclared variable.
 
Back
Top