Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 58
Default 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-



  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,885
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Message boxes JaB Excel Discussion (Misc queries) 1 November 10th 05 12:02 PM
Message Boxes. mika.[_2_] Excel Programming 1 November 19th 03 12:17 AM
Newby question: how to add icons to message boxes? Olly[_3_] Excel Programming 2 November 11th 03 09:33 AM
Disabling popup boxes Robert Chapman Excel Programming 1 September 30th 03 11:23 AM
Disabling the Update links message L Buchy Excel Programming 2 July 23rd 03 06:38 PM


All times are GMT +1. The time now is 12:37 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"