Excel VBA Video: Show Message Before Printing

Show Message Automatically Before Printing Excel Sheet

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.

Order form worksheet with customer name selected
Order form worksheet with customer name selected

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.

CustMsg06

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

_____________

Leave a Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.