This video is one of Clayton Lock’s original videos and you can download the file used in this video.
This video covers vital learning for anyone who wants to get started with Excel VBA. Mastering the techniques in this video will save you hours and hours
The video covers how to use break points in the Visual Basic Editor in Excel to stop code as it is working through. It then goes on to show you how to use the watch function to check the values of any variable at any time in the code.
You will also learn how important F8 is in the Visual Basic Editor in Excel
Finally you will see how you can use the watch window to look at all the properties of any object in your code. Really useful (if not vital) things for you to learn if you are going to get started with VBA.