Click a button: Check sheet, display errors?

Howdy all,

Wondering if such a thing is possible: I've got a sheet that I use to enter a number of different things for orders. The user needs to make sure they enter some key data in some fields while other fields are purely optional. Additionally, some fields have to add up to other fields. The quantity entered in area A needs to equal the quantity entered in area B.

Right now I have it that there are logic tests for each critical area. There's a hidden spot in my sheet where I've got if-statements basically setup so that: "If cell f18 is blank, then put a 1 here, otherwise but a 0 here." Or I have something like this: "If a+b+c = x+y+z, then put a 0 here, otherwise put a 1." In short, 1 = bad, 0 = good. Let's say these cells are x20, x21, x22, x23, x24, and x25.

So, what I want to do it setup a button so that when the user click it a macro or vba checks cell x20. If that cell's value is 1 (ie, bad) then Excel displays a message saying: "You haven't entered customer name." Then it checks cell x21. IF that value is 1, then it display a message like: "Quantities do not match." Basically anytime it sees a 1 in any of those cells it should display a warning message and then stop the script.

However, it all cells in the range it checks have a 0, then it should change a cell from one value (in progress) to another (complete). Is something like this possible?

Hi rrbee,

Something like this?

Please Login or Register  to view this content.

Instead of set ws = worksheets("name") use this:

Please Login or Register  to view this content.