When code execution gets to the call for ChangeFont, I can press SHIFT + F8, the ChangeFont sub is executed, but I don't have to wait for this, and the code pauses again at the next line which is the End Sub statement.

My sub ListNumbers calls another sub ChangeFont. In this case you can 'step over' the 2nd sub and immediately continue executing the code in your 1st sub. If your code calls another sub, you may not want to step through each line of code in that 2nd sub. You can press F8 to execute every line of code, one at a time, until the sub ends. Notice that the DIM statements declaring variables are not included in this and are stepped over. The next line to be executed will be highlighted in yellow, with a yellow arrow pointing to it.Įach time you press F8, the line highlighted in yellow is executed, and the next line to be run is highlighted.

With the cursor in the sub, press F8 to execute one line of code at a time. You can't use F5 or F8 to run a sub that requires parameters, or to execute a function. When you place the cursor into a sub, either with a mouse or using the keyboard, press F5 to run that sub.Īlso, if you are stepping through code (F8 - see below) and get to a point where you are happy with what you have checked, you can press F5 to execute the rest of the code. Whilst this isn't listed in the Debug menu, you will use it when debugging. If you look at the Debug menu in the VBA editor this is what you will seeĪlmost all the tools (or commands) have a shortcut key and you should learn these as it's a much quicker way to debug, rather than going to the menu all the time. When I say 'tools' what I am referring to are ways the VBA editor allows us to interact and run the code. MyRange.Offset(counter).Value = counter - 1 xlsx file please ensure your browser doesn't change the file extension on download. Excel for Decision Making Under Uncertainty Courseĭownload the workbook.Excel for Customer Service Professionals.

Visual basic for applications script