BeforePrint

Hello,
First, just let me say that this is my first post here, and any assistance is greatly appreciated. I'd prefer tips, rather than a copy & paste fix

I'm working on a pretty simple code, but I'm completely boggled. My VBA knowledge is pretty limited, so I know that it's blatantly obvious what I am doing wrong, but I have been looking at it for too long to notice the error for myself . A quick forum search yielded little pertinent info, so I come here begging for help.

I want my worksheet to require validation of entry data before printing, so I decided to use the "Workbook_BeforePrint" event, and display a simple dialog box with an "ok" or a "cancel" button as input options.

The problem is that, as coded, "cancel" button does not cancel the print.

Here is the sample code:

Workbook_BeforePrint:

Please Login or Register  to view this content.

Userform

Please Login or Register  to view this content.

Thanks in advance for any assistance! I look forward to hearing from you.

Hello Quail,

Welcome to the Forum!

Remove your variable "CancelPrint" from where it is now and declare it in a Standard VBA Module.

Adding a Standard VBA Module to your Project
1. Open your workbook
2. Press the keys ALT+F11 to open the Visual Basic Editor
3. Press the keys ALT+I to activate the Insert menu
4. Press M to insert a Standard Module
5. Paste the code by pressing the keys CTRL+V

The variable will now be visible to all parts of your code.