Unused vars and unattached codes

  • Thread starter Thread starter Lars Brownies
  • Start date Start date
L

Lars Brownies

Is there perhaps an easy way to detect unused and therefore superfluous
variables in code. Is is also possible to detect code of which the objects
are not existing anymore?

Thanks,
Lars
 
You can download a utility from www.mztools.com. One of the useful things it
does is to allow you to add error-handling to any routine, and you can
configure it to add the name of the procedure to the line that calls the MsgBox.

Great little utility.

Another thing it does is check your VBA code and list unused Constants and
variables. Look at the Other Utilities dropdown for an item Review Source Code.


John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County
 
Excellent! Thank you.

Lars

John Spencer said:
You can download a utility from www.mztools.com. One of the useful things
it
does is to allow you to add error-handling to any routine, and you can
configure it to add the name of the procedure to the line that calls the
MsgBox.

Great little utility.

Another thing it does is check your VBA code and list unused Constants and
variables. Look at the Other Utilities dropdown for an item Review Source
Code.


John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County
Click to expand...
 
Back
Top