Shift-F8 Step over the line by running the procedure on the current line without going into it and stepping through each line
Experts Exchange Solution brought to you by
"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.
Managed service contracts are great - when they're making you money. Yes, you’re getting paid monthly, but is it actually profitable? Learn to calculate your hourly overhead burden so you can master your IT services pricing strategy.
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
Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.
apply to F8 too (making it Shift-F8)
From novice to tech pro — start learning today.
Members can enroll in this course at no extra cost.