Tony Miall
Active Member
- Joined
- Oct 16, 2007
- Messages
- 304
Hi all,
I have a macro that when run sends part of a sheet to a new workbook.
There is cell (R23) in the original work book with a formula that displays various statuses based on user input ie "ORDER VERIFIED", "PRICING ERROR", "OVER SPEC QUANTITY" etc.
What I want to happen is exit the macro and display a message to the user, something like "THIS ORDER IS NOT VERIFIED, CHECK SPECIFICATION" if the status in R23 does not equal "ORDER VERIFIED".
I have searched other posts but can't find what I'm after.
Appreciate any help.
Thanks, Tony
I have a macro that when run sends part of a sheet to a new workbook.
There is cell (R23) in the original work book with a formula that displays various statuses based on user input ie "ORDER VERIFIED", "PRICING ERROR", "OVER SPEC QUANTITY" etc.
What I want to happen is exit the macro and display a message to the user, something like "THIS ORDER IS NOT VERIFIED, CHECK SPECIFICATION" if the status in R23 does not equal "ORDER VERIFIED".
I have searched other posts but can't find what I'm after.
Appreciate any help.
Thanks, Tony