![]() ![]() 01:13 Well, in this case, there's actually one of the commands, and.01:10 But what if I need to step through and see what's actually happening?.01:05 Normally, when we run our code, it runs from top to bottom.01:03 show you what ends up happening with this. ![]() ![]() 00:59 And what I'd like to do, is I'd like to actually go through and.00:56 So, what we can see is we have our code here.00:50 Get rid of the watches window as well, and let's get rid of the locals window too.00:47 So I'm just gonna get rid of the project and properties window.00:44 some stuff that I don't need here, so I get a little bit more space.00:40 Side by side with my visual basic window, I'm going to get rid of.00:37 I've also docked my Excel window.00:34 the code cleanup changes we made are in here.00:30 This is, basically reset the schedule back to January 31st, but.00:27 I have my workbook Debugging Basics open.00:25 You'll notice in this particular case here,.00:21 after being able to read code is the ability to actually debug it.00:17 It's just the way it is, and one of the most important things that we can have,.00:14 when you write code, you will write buggy code.00:11 This is one of the big pieces that you're gonna end up finding,.00:08 some of the more critical debugging steps.00:05 Now the next thing that I wanna look at is,.Stepping and running can be used in combination step the first few lines of code and then run the rest with the Play button (or F5), or stop with the Reset button.You can also press F8 to run Step Into.Stop running a macro by clicking Reset button (blue square) on the Debugging toolbar.Run the remaining portion of the macro by clicking the Play button (green arrow) on the Debugging toolbar.Move the execution point up or down by dragging the yellow arrow next to the highlighted line and dropping it on the line of code you would like to execute.The active line of code which is about to be executed will be highlighted in yellow.The Step Into button on the Debugging toolbar allows you to execute the macro line by line. When you need to execute a macro line by line, to see what is happening along the way. Understanding how to debug code using the Step feature. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |