Jacob is extremely knowledgeable, and also incredibly responsive. I worked with Christopher and Jacob and couldn’t be more delighted with the level of customer service I received. After having two other firms take on the project and then bail, I was panicked and desperate to get the project completed in what was now a very tight time frame. I had the pleasure of working with Excel & Access on a very intricate Excel project involving a massive spreadsheet that housed years’ worth of data. This is how I used to perform this method, until I was shown the method above. Why I didn’t know this before astonishes me, but I’m thanking Jordan because I will use this CONSTANTLY! Method 2 Simply click and drag the yellow arrow back up to where you want to execute the code from.īam! That easy. This awesome method is by far the easiest way I’ve ever seen, and while others may have known this for years, Jordan showed it to me and blew me away. To make this code actually execute we need to get the highlighted line back up to where that code runs. In the above picture the first time ‘MyVariable’ is set was changed to “xyz” instead of “abc”, all while in break mode. If we execute the next line of code it will be changed to “def”.Īt this point if I change the original variable, which could be for many reasons, an example being maybe I just want a different value for ‘MyVariable’, so I change the value while in break mode. So at this point the variable ‘MyVariable’ is set as a string to “abc”. In the below picture we’re executing code (in break mode) and the highlighted line is the code which will be executed the next time we press F8.
Here we will show two methods of going back up in your routine with the line currently being executed (i.e. (I realize this is a very simplistic example, but bear with me, this will make sense it a moment.) There is no built-in method to step back to a previous line, it’s always executing going down lines of code, never back up. If we’re stepping through this code and we come to the line where the variable is set for the second time (MyVariable “def”), say we do NOT want to execute this line, but we want to go back and run the line where the variable is set the first time.
0 kommentar(er)
