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.

Attached Files

Quality Check Recorder v2.xlsm (42.5 KB, 8 views)