Required Fields

I need help again. I'm so confused. It doesn't seem like a hard concept but it definetly is tricky. I have a new customer setup for that a ton of people use and there are errors on them all the time. I'm trying to elimate these by requiring certain cells to contain data. They must not be blank. What I have right now is just alot of If/Then statements that

Please Login or Register  to view this content.

So it works to the point that if one of those cells is blank, it tells you what you must enter. What I would like for it to do is to go through each field and check to see if there is data there, and if there isn't, I'd like to to stop at that field so that the person could type what they needed there. And once they finished typing they'd try and send the form again with another macro I have and it would repeat the process of checking. I would like it to continue runnin my macro called "FinalMacro" IF all of the fields I need to contain data, do.

It sounds confusing and let me know if I need to clarify something. Thanks a bunch and you guys are amazing!!!

-Jerad

Try this:

Please Login or Register  to view this content.

ska

Thank you so much! It works! I'm still trying to figure out how when it ends it will go to that specific field. I think you wrote it in your code, I'm going back to check now. Thanks again! You're great!

This will check each of the requiredCells and, if it is empty, prompt the user for the correct info and put it into the cell required.

Please Login or Register  to view this content.