Shift-F8 Step over the line by running the procedure on the current line without going into it and stepping through each line
Do more with
Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!
you could is set a breakpoint on the next line of code and then press F5.
You might however be able to set up a Windows shortcut for what you want to do
If you want take it even further, create keyboard shortcuts for quick access to Windows 7 settings. Step 1: Right-click on one of the shortcut icons you just created and select "Properties." Step 2: In the "Shortcut key:" field, type a key combination to use as a keyboard shortcut.
i = UnZip(sDownloadFolder & sLastFile, sDestinationFolder, False)
If i = 0 Then
sDestinationFolder = "C:\Application\"
If Dir(sDestinationFolder & NewestFile(sDestinationFolder, "*." & sExt)) <> "" Then
If Dir(sDestinationFolder & "Tables." & sExt) <> "" Then
Kill sDestinationFolder & "Tables." & sExt
Name sDestinationFolder & NewestFile(sDestinationFolder, "*." & sExt) As sDestinationFolder & "Tables." & sExt
Open in new window
#If Testing Then
' Don't do anything
#If Not Testing Then
then the following code will bypass the calling of SomeSub.
Step Over is similar to Step Into except that as its name implies it will step over or skip the current line. Note that it doesn't skip the execution of the line, only the stepping through. In other words if the current line is a call to a long Sub that you don't really care about, stepping over will execute the call and then pause at the line following the call.
Have you tried setting breakpoints and using F5?
For example in the code you posted you could put breakpoints on line 1 and line 3.
click the Debug menu's 'Step Out' button.
If it's Shit+F8 and you assign it to, say, F9, how would that prevent you from wandering into the subs you don't want to step through?
why not put a breakpoint on the function itself?
So you want to F8, F8, F8,...F8 until you get to a certain sub and then press F9 and have it step over, right?
Right-click the desktop shortcut of the application, then click Properties > Shortcuts.
Not either, I just want to use f9 all the time...no switching keys and no using two keys
That's not possible.
Step 2: Start the Keyboard wizard, and change the assignments
Open the Keyboard item in Control Panel. ...
On the Key Settings tab, select the key that you want to change.
To change the command or the program assignment, click Configure. ...
Select the appropriate options, and then follow the instructions
apply to F8 too (making it Shift-F8)
IT issues often require a personalized solution. With Ask the Experts™, submit your questions to our certified professionals and receive unlimited, customized solutions that work for you.
Start 7-Day Free Trial
Start 7-Day Free Trial