S
ServiceChris
Hi all. Back for my last query of the week (I hope)
I have a sheet with lots of nice validation on it - some in the for
of macros and some just data validation. However, the one last thing
would like to validate is that an entry has been put in all th
mandatory fields before the user leaves that line. So, for example
once they enter a value in C4, they must also enter one in C6, C7, C9
C10, and optionally in C5 & C9. The same works whichever field the
first enter data in. Once one field (optional or mandatory) is filled
I do not want them to be able to leave the line without all th
mandatory ones being filled. They can move left and right as much a
they want, but not up or down, or use the mouse to click elsewher
without a full row being entered.
Any suggestions?
Thanks in advance.
Chri
I have a sheet with lots of nice validation on it - some in the for
of macros and some just data validation. However, the one last thing
would like to validate is that an entry has been put in all th
mandatory fields before the user leaves that line. So, for example
once they enter a value in C4, they must also enter one in C6, C7, C9
C10, and optionally in C5 & C9. The same works whichever field the
first enter data in. Once one field (optional or mandatory) is filled
I do not want them to be able to leave the line without all th
mandatory ones being filled. They can move left and right as much a
they want, but not up or down, or use the mouse to click elsewher
without a full row being entered.
Any suggestions?
Thanks in advance.
Chri