LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 21
Default Single message box for multiple IF statements

I have three separate IF statemnts. Currently when they
are true, the following code is executed:

First IF statement

MsgBox "Please enter a Client Name"
Cancel = True

Second IF statement

MsgBox "Please enter a Sub Client"
Cancel = True

Third IF statement

MsgBox "Please enter a File Barcode"
Cancel = True


This produces three message boxes.

Is it possible to have one message box that shows the
statements that are true.

 
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
Sumproduct, single criteria identified within multiple in single c Monte Excel Discussion (Misc queries) 4 July 18th 09 11:21 PM
Multiple formats in a single cell with multiple formulas Zakhary Excel Worksheet Functions 1 May 2nd 08 12:08 AM
Printing single pages from multiple worksheets in a single print job [email protected] Excel Discussion (Misc queries) 2 April 27th 07 06:11 PM
Find Multiple instances of Single Criterion in Row & Return To a Single Col Sam via OfficeKB.com Excel Worksheet Functions 16 May 10th 06 03:00 AM
how many if statements can i use in a single cell ? Kypreo Excel Worksheet Functions 5 November 23rd 05 09:23 PM


All times are GMT +1. The time now is 08:19 AM.

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"