Question about disabling message boxes if possible

  • Thread starter Thread starter TBA
  • Start date Start date
T

TBA

Excel 2000
Windows 2k Pro

I use lots of message boxes for testing a utility I'm writing, and I'm
wondering if there's a way to toggle message boxes on or off in case I want
to test a "clean" run. Can it be done?

TIA

-gk-
 
Hi TBA

you can use conditional compiling with the "#If...Then...#Else"
construct. e.g.
#If Test_enabled Then
Msgbox "Test Output"
#Else
....
#End If

With the constant 'Test_enabled' you can toggle your messageboxes
HTH
Frank
 
Back
Top