message box

thedeadzeds · #1 05-14-2013, 03:59 AM

Guys,

I have this code and it works fine but Is there a wasy to change it to show

If d6 = "Assistance" then message box to show "J6 must be completed"
If d8 = "Assistance" then message box to show "J8 must be completed"
If d10 = "Assistance" then message box to show "J10 must be completed"
If d12 = "Assistance" then message box to show "J12 must be completed"
If d14 = "Assistance" then message box to show "J14 must be completed"

and so on and so on

Thanks
Craig

Code:

Code:

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
 
If Worksheets("sheet1").Range("D6").Value = "OK" Then
Exit Sub
Else
MsgBox ("You need to complete the task box")
End If
 
End Sub

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Message replys are shown at the bottom of the message, how can I get them to the top	Gardy	Outlook	3	05-23-2012 01:20 AM
Message Box	ibrahimaa	Excel Programming	3	02-26-2012 02:32 PM
Message Header	ritjohns	Outlook	1	11-16-2011 01:20 PM
Proofing message	geralds34	Word	2	05-02-2011 06:07 PM
Error message	White House	Outlook	1	12-07-2010 04:52 AM