To build debugging and profiling into your code, add this to the end
of code lines:
'Code line Add this line (n should be replaced
'by a unique number)
i = j + 1 '*dbg* "Debug n" & time
Turn debugging/profiling on by simply doing a replace on all modules
of '*dbg* with :debug.print. When you run your code, the output will be
sent to the debug window. To turn off debugging/profiling, replace :debug.print
with '*dbg.*
Even more interesting is the fact that you can do this at the procedure
level as well. For example:
Sub Form_Load () '*dbg* "form_load:" & Time;
It's quick, easy and you get access to all the articles on DevX.
This registration/login is to allow you to read articles on devx.com. Already a member?
To become a member of DevX.com create your Member Profile by completing the form below. Membership is free!
If you have a hot tip and we publish it, we'll pay you. However, due to accounting overhead we no longer pay $10 for a single tip submission. You must accumulate 10 acceptable tips to receive payment. Be sure to include a clear explanation of what the technique does and why it's useful. If it includes code, limit it to 20 lines if possible. Submit your tip here.
