Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 11-17-2015, 07:55 AM
Officer_Bierschnitt Officer_Bierschnitt is offline Taming the VBA_debugger Windows 7 64bit Taming the VBA_debugger Office 2013
Advanced Beginner
Taming the VBA_debugger
 
Join Date: Oct 2015
Posts: 87
Officer_Bierschnitt is on a distinguished road
Default Taming the VBA_debugger

Hi,

I often use the "debugger" in the VBE to debug my scripts - that is, I use breakpoints or I step through the script line by line by pressing F8 repeatedly.
What happens quite often is that either
- after a while, the system just decides that going line by line is too slow and
just executes the remainder of the script at normal speed
OR
- the moment I execute a line of code opening a workbook that contains
macros itself, the VBE_code_window shows that macro instead of the one
I'm just working on and the execution_line_highlight is gone.

Can anybody confirm to me why this tends to happen and what I can do to avoid it?

Thanks a lot!

Best regards,

Officer_Bierschnitt

P.S.: Can that have something to do with the fact that there is VBA_code in one of the sheets here rather than in a general module?


P.P.S.: Maybe, but that is apparently not all - now I have moved the code to a general module, but the same thing still happens ...

Last edited by Officer_Bierschnitt; 11-18-2015 at 03:42 AM. Reason: additional info
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Taming the beast: columns mrmagoo Word 6 08-23-2012 03:06 PM
Taming MS Word clemkonan Word 0 02-26-2010 03:11 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:23 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft