disable save event if condition not met

ninjabass

New Member
Joined
Apr 5, 2011
Messages
2
Hi all,

I tried posting the text below on another forum but no one seemed to be able to help, Hope someone here can steer me in the right direction!


Have what probably a fairly simple question but I'm pretty much a beginner at excel so the answer is eluding me, hope someone can help ...

Here's what I want to do:

if cell B18 contains any data then cell F18 must be filled in else don't allow sheet to be saved AND/OR don't allow user to move to next row

Couple of things that may or not make a difference:

1. The selection in B18 is from a named range (part) without a drop down list.
2. The selection in F18 is from a named range (REASONCODE) with a drop down list.

So, to make it a little clearer.

The sheet is used to return obsolete stock back to our warehouse. B18 contains the part number and F18 contains a reason code. We don't want to allow stock to be sent back without a valid reason code....

Thanks for taking the time to read through my query and hope you can help!
 

Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.

Forum statistics

Threads
1,213,497
Messages
6,114,002
Members
448,543
Latest member
MartinLarkin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top