Compile Project?

[MDW]

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.

 

[Tim Ferguson]

Improve performance?

A little bit, yes.


Tim F

 

[John Spencer (MVP)]

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.