Listing all compile errors at once

  • Thread starter Thread starter Fred Smith
  • Start date Start date
F

Fred Smith

I turned on Option Explicit to force myself to declare all variables. But
every time I ran my procedure, VBE would stop at the first error. Is there
any way to get the compiler to show all the errors, so I can fix them all at
once?
 
Not sure this is exactly what you're looking for but in the Debug menu,
"Compile VBA Project" will find the syntax errors without running the code.
 
Fred,
Short answer is No. That's why the compiler errors, because it cannot
continue.
If you find a spelling mistake or some such repeated error, use Edit ->
Replace to change all occurences of said error. This will reduce the number
of times the compiler halts.
Guess you learned why you should use Option Explicit from the start.

NickHK
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top