Forum Discussion
VBA to check for completeness of row entry
Requesting for help for VBA for the following scenario: let us assume i is the number of rows from 2 to 1001 (checking range C2:G1001) The criteria is this: if Ci & Di are filled with data then Gi...
To make it much simpler:
The Criteria now is > if ever Di is inputted with data, the cursor should go directly to Gi and await an entry of greater than zero otherwise a prompt will appear for correct entry. Di & Gi is in the same row.
criteria: Gi got to have a value of greater than zero if ever Di is inputted with data.
To bypass this check, Di have to be erased. The range of checking is from Row 2 to 1001 (range D2:G1001).
following this logic, if Di & Gi are filled, Gi can not be erased unless Di is erased first.
No 'vice-versa' - meaning there is no criteria for Di to be required if ever Gi is inputted. Just from Di to Gi only. Maybe this VBA is makeable.....(under what sub should the code be placed?)
many many thanks