948 Steps to 6 Figures by Learning Excel-VBA and Other Skills

Step 107 - Debugger

A debugger is used to help find coding problems.

It allows you to step through your code, line by line, following the flow of the code, while checking that everything is okay.

Some of the main features of a debugger are:

Setting Breakpoints

Stepping through code

Examining values in variables

Changing which line of code is executing

Some of the features of the VBA Debugger:

Write code while debugging

Go back in code or skip code

Stop the code

Steps

Open a new spreadsheet

Usage of a debugger:

To find bugs

To understand code

Types of bugs

Logic errors

Compile errors

View Excel and Debugger on two windows or split screen.

Events are hard to debug.

Figure out were the code is

Hold the shift key

Find code associated with a button

Find code associated with a Shortcut key

What are the top commands to use in the debugger

Go to the Debugger Alt F11

Go from Debugger to Excel Alt F11

Immediate Window Ctrl G

Project Explorer Ctrl R

Properties F4

Code Window F7

Debugging

Next F8

Step Over Shift F8

Step Out Ctrl Shift F8