Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
If IsEmpty(Sheets("Sheet1").Range("A2")) Then
Sheets("Sheet1").Activate
Range("A2").Select
MsgBox "Fill in the required cell A2."
Cancel = True
End If
End Sub
For this code, how am I suppose to modify it such a way that if B2 or any other column in B has value, A2 or any other column in A is required also?