Skip to main content
Home Programming with Excel VBA
Main navigation
  • Home
  • Lists
    Lessons Exercises Badges Patterns Principles
  • Search
  • Login
Lessons
  • + Getting ready
    • What is the course about?
    • Why should you care?
    • How the course runs
    • Working together
    • Gather.Town
    • Using this site
    • Exercises
    • Feedback
    • When you get stuck
    • How to succeed
    • Set up Excel
    • Your professor
    • Let's get into it!
  • Your learning style
  • + Simple programs
    • The first program
    • Writing the first program
    • Adela's turn
    • Generalize
    • Dialogs
    • Numeric expressions
    • Strings
    • Secluded Cells
    • Easy is good
    • Debugging
    • More debugging
    • Another worked example
    • Exercises
  • + Decisions
    • If-then-else
    • Logical operators
    • Multiway
    • Nested ifs
    • Guard pattern
    • Basic validation: strings
    • Basic validation: numeric
    • Better validation
    • Vladidation in C#
    • Exercises
  • + Data analysis
    • Data tables
    • Ranges
    • When Ranges have blank data
    • Processing a Range
    • Normalizing
    • Range validation
    • Exercise walkthrough
    • Validate then process
    • Filtering
    • Min and max
    • Adela programs
    • Exercises
  • + Tips
    • Blocked macros
    • Common errors
    • Excel objects
    • Excel on Macs
    • Rounding numbers
    • Shortcut keys
    • VBA documentation
    • Pseudents

Debugging

More debugging

The debugger doesn't actually fix your code for you. It steps through code. How does it help? Adela shows us.

Goat party planner

Fix the bugs in Cthulhu's party planner

Read code actively

When code doesn't work, the first thing to do is carefully read through the code.

Incremental testing

Write a little code, then test it. Write a little more code, then test it.

Subscribe to Debugging

DO NOT START HERE

Read the lessons on the left of the screen. All exercises are embedded in the lessons.

Creative Commons Attribution-ShareAlike 4.0      Terms of use