Hi All
Really hoping you can assist here.
I am using the below vba code for a macro button, essentially once clicked it changes to my 'quotation' worksheet and prints a range of data to PDF.
This is working perfectly, however please could someone assist in what additional code I should use to achieve the following:
When running the macro, I would like it to firstly check if cell O19 is blank, if it is not then resume the macro but if it is blank then prompt the user with a vba msgbox to warn this is blank while providing the user with two options here, either ignore and proceed to run the macro as normal, or cancel the macro and revert back (leaving cell O19 selected) so that the user can then enter data in cell O19.
Many thanks in advance for any help with this.
Cuzzaa
Really hoping you can assist here.
I am using the below vba code for a macro button, essentially once clicked it changes to my 'quotation' worksheet and prints a range of data to PDF.
Code:
Sub GenerateQuotate()
'
' GenerateQuotate Macro
'
'
ActiveWindow.SmallScroll Down:=-3
Sheets("Quotation").Select
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True, _
IgnorePrintAreas:=False
Sheets("Dashboard").Select
Range("F14").Select
MsgBox "Your quote has been generated!", vbInformation
End Sub
This is working perfectly, however please could someone assist in what additional code I should use to achieve the following:
When running the macro, I would like it to firstly check if cell O19 is blank, if it is not then resume the macro but if it is blank then prompt the user with a vba msgbox to warn this is blank while providing the user with two options here, either ignore and proceed to run the macro as normal, or cancel the macro and revert back (leaving cell O19 selected) so that the user can then enter data in cell O19.
Many thanks in advance for any help with this.
Cuzzaa