How to disable certain code segment?

[Sing]

Dear Excel Gurus,

In C, one can mask off certain code segment by using macros like;
#ifndef DISABLE_XXX
//Code to be disabled
#endif

How can I do the same thing for Excel VBA?

Thank you in advance.

 

[SteveM]

Dear Excel Gurus,

In C, one can mask off certain code segment by using macros like;
#ifndef DISABLE_XXX
//Code to be disabled
#endif

How can I do the same thing for Excel VBA?

Thank you in advance.

If Condition = TRUE Then
Exit Sub ' to terminate execution of the sub
and return to the calling Sub
End ' to terminate and close (almost)
everything. See the VBA help for details.
EndIF

 

[Chip Pearson]

You don't have the flexibility that you have with C, but you can use
conditional compilation.

#Const EXEC_THIS_CODE = False

Sub AAA()

Debug.Print 1
#If EXEC_THIS_CODE Then
Debug.Print 2
#End If
Debug.Print 3
#If EXEC_THIS_CODE Then
Debug.Print 4
#End If
Debug.Print 5

End Sub


--
Cordially,
Chip Pearson
Microsoft MVP - Excel, 10 Years
Pearson Software Consulting
www.cpearson.com
(email on the web site)

 

[FSt1]

hi
see this site
http://cpearson.com/excel/vbe.htm

regards
FSt1