report with loops and conditional printing

Hi All,

I'm making a report form in dutch for my work, certain cells have to be filled in that's why i made this program. I want to create a loop so that if something is left blank c5 it loops back until that cell is filled, then it can check if cell f5 is filled in if it is not it has to loop back until this cell is filled.
the next part is that I want to work with 9 cells which have to be filled in but if one or more of them is filled in it is enough. (probably with or/and)
the last part is that they should not be able to save the report until everything is filled in.

Please Login or Register  to view this content.

Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #3 requires code tags. I have added them for you this time because you are a new member. It would be very helpful to indent code to show structure. --6StringJazzer

Maybe just count the cells?

Please Login or Register  to view this content.