Macro-Verify required fields before proceding with routine (save)

Greetings,

I am trying to get a macro that will check and stop (alert) for required cell incompleteness before running the rest of my macros. I found a workbook before_save macro, but it isn't working for me. Listed in the macro are the cells that are required on my worksheet that need to have a value other than " ". I would like this macro to run first after activating the command button I have my other macros attached to.

Please Login or Register  to view this content.

Another question is if I list the cells in a range ie B18:B21, and lets say B19 is missing, would it get overlooked if there was some value in the other parts of the range? I am looking for the macro to flag any cell listed that may be missing information.


Here is where I order macro operations:

Please Login or Register  to view this content.

Thank you for any assistance or advice you may be able to provide.


Patrick

Your first code is worksheet event code, you need to put it into a code module like your other procedures, then you call it as you do the others

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook. Don't upload a picture when you have a workbook question. None of us is inclined to recreate your data. Upload the workbook and manually add an 'after' situation so that we can see what you expect. In addition clearly explain how you get the results..
To attach a file to your post, you need to be using the main 'New Post' or 'New Thread' page and not 'Quick Reply'.
To use the main 'New Post' page, click the 'Post Reply' button in the relevant thread.

Start by selecting all the cells that must be filled in. Create a named Range called "CheckRange" to represent the selected cells. Then run this code from the button

Please Login or Register  to view this content.