Thread: [Solved] message box
View Single Post
 
Old 05-14-2013, 03:59 AM
thedeadzeds thedeadzeds is offline Windows XP Office 2003
Novice
  
Join Date: May 2013
Posts: 5
thedeadzeds is on a distinguished road
Default message box
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
Reply With Quote