See if this helps do what you're after.
Added macro to module 1 to apply .OnAction macro to be run by the column E checkboxes when clicked.
Added columns to "Recorded Errors" in order to retrieve status when changing customers in drop down in A1.
Used Worksheet_Change event on module of "Quality Check" sheet for retrieval.
Module 2 has the macro that runs each time one of the column E checkboxes is clicked.
|