Home / MS-Excel / General Formatting

VBA Debugging Tips

Debugging your procedures can be a frustrating job, even during the best of times.

Here are a few tips to keep in mind when tracking down programming problems.

Following these sections:

Indent Your Code for Readability:
(VBA code is immeasurably more readable when you indent your control structures. )

Enter VBA Keywords in Lowercase:
If you always enter keywords in lowercase letters, you can easily detect a problem when you see that VBA doesn't change the word to its normal case when you move the cursor off the line.)

In this tutorial:

  1. Indent Your Code for Readability
  2. Enter VBA Keywords in Lowercase