Hello there!
Can someone please help me create a VBA code for a message box to appear if cell O16 has been left blank?
This is part of a larger macro to transfer data from the tab "Pricing Sheet" onto a tab called "Quote Summary" so I am wanting to put this coding at the very beginning and then if cell O16 is blank, the macro stops, and if it is not blank, it can proceed and copy all data as it is supposed to.
Thank you in advance!!
Here is what I have right now:
'message box for blank start date
With Sheets("Pricing Sheet")
If .Range("O16") = "" Then
.Select
.Range("O16").Select
MsgBox "Please enter the start date in cell O16"
Cancel = True
End If
End With
Can someone please help me create a VBA code for a message box to appear if cell O16 has been left blank?
This is part of a larger macro to transfer data from the tab "Pricing Sheet" onto a tab called "Quote Summary" so I am wanting to put this coding at the very beginning and then if cell O16 is blank, the macro stops, and if it is not blank, it can proceed and copy all data as it is supposed to.
Thank you in advance!!
Here is what I have right now:
'message box for blank start date
With Sheets("Pricing Sheet")
If .Range("O16") = "" Then
.Select
.Range("O16").Select
MsgBox "Please enter the start date in cell O16"
Cancel = True
End If
End With