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...
Maybe my post on this subject is not clear.
I don't know which of the following will capture the event:
Private Sub Worksheet_SelectionChange(ByVal Target As Range) or
Private Sub Worksheet_Change(ByVal Target As Range)?
the scenario: (i is any row number) whenever Ci and Di (in the same row) are inputted with data, the cursor should automatically go to Gi and await an entry of greater than zero otherwise a prompt for correct entry will appear. Either Ci or Di can be erased to bypass this check.
following the logic, if Ci,Di & Gi are all filled with data, Gi can not be erased unless either Ci or Di is erased first. I need a vba for this.
many many thanks