Before Save
If Sheets("Quote").Range("K17").Value = "" And Sheets("Quote").Range ("B5:D5").Value <> "" Then
MsgBox (Range("F5").Value) & ", is this a Prevailing Wage project?", vbOKOnly, "Prevailing Wage"
Range("K17").Select
If vbOK Then Cancel = True
I cant seem to get this to fire when I add the second requirement, in bold, for the msgbx to fire. and thoughts on what the probelm might be??
Range(B5:D5) is a merged cell, which houses only text.
thanks
If Sheets("Quote").Range("K17").Value = "" And Sheets("Quote").Range ("B5:D5").Value <> "" Then
MsgBox (Range("F5").Value) & ", is this a Prevailing Wage project?", vbOKOnly, "Prevailing Wage"
Range("K17").Select
If vbOK Then Cancel = True
I cant seem to get this to fire when I add the second requirement, in bold, for the msgbx to fire. and thoughts on what the probelm might be??
Range(B5:D5) is a merged cell, which houses only text.
thanks