If one cell contains #, & other cell is blank, show message & require blank be resolved

Thank you in advance to any help that comes my way. I am trying to figure out how to make the following happen:

If B5:B6 contains numbers, and C5 is blank, then show messagebox that says "You must select a code for your time."
If B7:B8 contains numbers, and C7 is blank, then show messagebox that says "You must select a code for your time."
If B9:B10 contains numbers, and C9 is blank, then show messagebox that says "You must select a code for your time."
If B11:B12 contains numbers, and C11 is blank, then show messagebox that says "You must select a code for your time."
If B13:B14 contains numbers, and C13 is blank, then show messagebox that says "You must select a code for your time."

If C5:C13 contains any information, and B16 is blank, then show messagebox that says "You have coded a day with no scheduled hours. Please enter the number of hours you were scheduled for the day you have coded."

Your tests are not clear whether all the values must contain numbers or any one of them contains numbers so in those cases I assumed that if in any cell of the range contained a number then the message would be shown...

The code in the Worksheet_Change sheet would go something along these lines.... this should get your started.

Please Login or Register  to view this content.

@tkowal...

If the "B" column contains NUMBERS, then the "C" column must contain a label. If the "C" column contains ANYTHING, then B16 must contain a number. (There is a circumstance in which the B column may contain the text "Days Off" and it is okay for the C column to be blank. The lables in column C may contain numbers, letters, or a combination of both.)

I guess I should also have mentioned that I do not want the worksheet to test for these things until a macro button with the code below is clicked. I took the code you suggested and inserted it into my existing macro. With how it is configured below, if column B contains numbers, but column C is blank, it does indeed give you the popup message. However, it also lets you click ok and continue with the macro. So right now it is more of an FYI, but I need for the user to HAVE to enter the needed info into column C before the rest of the macro can be completed.

Please Login or Register  to view this content.

ValidateMe.xlsm

Try this and see if it functionally does what you want?

At the top of my head, you could when the error is trapped set the cell to a value of an InputBox and then continue on?

Please Login or Register  to view this content.

This should pause execution until the Input box has been filled.

Perhaps simply exiting before doing your saves and print.....

Please Login or Register  to view this content.

Actually, I have one more question. What you suggested lastly works well within my existing macro to prevent the user from moving forward with errors. But I had a blank button available, and so I also created a "Test for Errors" button with the original code you suggested. How would I modify it slightly to show a message that says "There are no errors" if no errors are detected?


Finally, Cells in column B should be allowed to have the text "Days Off" without having to enter anything into the corresponding Column C. The code currently gives me the warning if I have "Days Off" but no code in colulmn C. How do I make an exception to this?

Not having your code in front of me..... something like this?

Please Login or Register  to view this content.

The second part of your "Final Question" ....

In each test... where you want the exception to occur add the if statement with UCase(Trim(....
UCase = make all the text Uppercase..some people type all upper or all lower case..
Trim = Strip off any unnecessary spaces...sometimes people add spaces before and after...

Please note that this code is not necessarily the most efficient... there are many other ways of doing what you require! My philosophy is first get it working then dwell on improving it!

Please Login or Register  to view this content.

I am glad....