ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Question about disabling message boxes if possible (https://www.excelbanter.com/excel-programming/288302-question-about-disabling-message-boxes-if-possible.html)

TBA[_2_]

Question about disabling message boxes if possible
 
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-




Frank Kabel

Question about disabling message boxes if possible
 
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



All times are GMT +1. The time now is 05:39 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com