Convenient way to ignore Debug.Assert ?

[Sing]

Dear Excel Gurus,

I put in several Debug.Assert in my code to catch bugs more easily. As I am
going to deploy the code soon, is there any convenient way to ignore the
Debug statements for the deployment version?

Thanks for your help.

 

[Rick Rothstein \(MVP - VB\)]

I put in several Debug.Assert in my code to catch bugs more easily. As I

am
going to deploy the code soon, is there any convenient way to ignore the
Debug statements for the deployment version?

You can use Edit/Replace in the VBA editor to replace them with blank lines.
Put this...

*debug.assert*

in the Find What field, leave the Replace With field blank and put a check
mark in the Use Pattern Matching check box.

The other possibility if you don't want to lose them completely is to turn
them into comments. Again, in Edit/Replace, put this...

debug.assert

in the Find What field and put this...

'debug.assert

(note the leading apostrophe) in the Replace With field.

Rick

 

[Dave Peterson]

You may want to add a public variable that you can toggle.

Public DevelopmentMode as Boolean

Then somewhere
DevelopmentMode = True

Then you could use
if developmentMode = true then
debug.assert ...
End if

Who knows if it's worth the effort for this project--but, heck, it may be worth
it when you get that first bug, er, enhancement request next week!