Warning Message pop up - without data validation

rk777

New Member
Joined
Aug 18, 2011
Messages
1
Hello,

I am posting here for the first time. Have been following this website for excel help for a while now. I have a project where I am trying to make a Warning or Stop msgbox pop up if a cell does not equal to 0. Here is what I am trying to do:
.....A......B
1 Active Code
2...x ........3
3...x ........2
4...x ........5
5...3 ........3 ...........In cell C5 I put this formula =A5-B5 = 0

I have two columns. If a user puts an x in the active column, they must select a reason code(from a set list) in the Code column. The total is done in each column using a countif function. In cell C5, I put a formula to do a subtraction(Active-Code) of the totals in each column. C5 needs to always be 0. If a user did not put a code or did not put an "x" in the Active column then C5 will not show 0, but a positive or a negative number. When that happens I need a Warning box to pop up to inform the user they made a mistake and they need to go check their data.

Could someone please help?

Thanks!
 
Last edited:

Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop

Forum statistics

Threads
1,224,587
Messages
6,179,740
Members
452,940
Latest member
rootytrip

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