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: 54
Default exception to MsgBox

I am currently running this code to prevent users from leaving a
TextBox (txtPO) empty:

If Trim(Me.txtPO.Value) = "" Then
Me.txtPO.SetFocus
MsgBox "Please enter a Purchase Order Number."
Exit Sub
End If

I would like this to only apply if "A," "B," or "C" are entered into
cboDealer which is on the same user form. Otherwise I want the user to
be able to leave this TextBox Empty. Can anybody provide me the
appropriate code?

Thanks in advance for all of your help!

 
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
sum of rows with exception of row x, y, z... lydia's Excel Discussion (Misc queries) 6 September 5th 09 03:54 PM
Exception list Gene Straub Excel Discussion (Misc queries) 2 January 28th 09 10:46 PM
Sum Based on Exception Cue New Users to Excel 9 May 22nd 08 12:44 AM
Sum Based on Exception Cue Excel Discussion (Misc queries) 7 May 21st 08 12:31 AM
Add an exception rule hotherps[_109_] Excel Programming 6 August 17th 04 05:51 PM


All times are GMT +1. The time now is 01:45 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"