Need help creating a Warning Message with two if statements

[mo4391]

Hello All,

I have the following code tied to a button in an excel sheet. It confirms that the user did want to print the sheet.

Please Login or Register  to view this content.

Now I need to take it one step further. After the user has confirmed they want to print I need the code to basically check the following before printing:

If Entry!B5="Fiber" then Entry!B6 must be a number greater than 0 else message box "Fiber Transport Selected - Please Enter Work Order #"
The user would then click "Ok" then go back to the worksheet and enter the work order number in the proper place.
If EntryB5 = anything else run the rest of the code.

Worksheet "Entry" is the same sheet the button I have the macro tied to is on, if that matters.

Thank you for any assistance

[stnkynts]

Try this. I didn't validate any of the code you already posted.

Please Login or Register  to view this content.

[mo4391]

Worked perfectly. Thank you