If the customer name is missing from an Excel worksheet order form, you’ll waste paper if you print that order form, and then have to reprint it.
See how to prevent that from happening, with a macro to show a message before printing.
Check for a Customer Name
Here’s the Order form worksheet, with a customer name selected. This macro will check that cell, to make sure that it isn’t empty, before printing.
Show an Error Message
Previously, you saw instructions for automatically showing an error message before printing, if data is missing from an Excel worksheet.
If a Customer name is not selected, the macro will prevent people from printing the order form.
See the Steps in This Video
Well, it took a long time (okay, half a year), but I finally uploaded a video that shows those steps.
Instead of reading the steps, you can watch how to do them. Then, try this technique in your own workbooks.
See All the Macro Steps
See all of the steps and all 5 videos on my Contextures website, on the Getting Started with VBA page.
The instructions and videos show how to do these steps:
- Record a Macro in Excel
- Edit the Recorded Macro
- Show a Message in Excel
- Show a Message Automatically
- Show a Message Before Printing
_____________