Hi,


I'm new to VBA and so was wondering if someone knew where I can find information on how to do something I'm working on.

Basically, I have a list of tasks that need to be completed for quality checks of customer statements that are being written. I've added checkboxes for each task to keep track of any issues performing the tasks, and would like a way that if they are checked off as the list is worked through (tasks screenshot), then a log of where the issue was can be made on a second sheet (log screenshot) linked to each customer.
I've figured out how to make a droplist at the top of the task list generated from the list of customers on the log sheet, and would like a way to link the checkboxes to each customer.

Can this be done? Thanks!

Are you able to record a macro of yourself manually doing what you want to happen when a check box is checked ?

Chances of assistance is greater attaching a workbook rather than pictures of sheet(s) in the workbook.

As in record a macro for each individual checkbox? I could try that. Would I be able to have a search for the customer name as part of that?

I've attached the file now. So my aim is a customer would be selected from the dropdown list, and then whoever is using this would work through the checklist of tasks ticking a checkbox if there was an issue.

The second sheet would serve as a log where each row is a customer, and the columns are the tasks, so the number of issues and where they occurred can be recorded per customer

Attached Files

Quality Check Recorder.xlsm (36.2 KB, 7 views)

I tried recording a macro and getting it to copy the contents of a cell (the dropdown of the customer name) and then do a ctrl + F to find the row of that customer to fill in the cell. However, when I run the macro it just reverts back to the customer which I recorded the macro on. When I view the code to edit it, it specifies the customer. How should I write it so it copies the cell contents and doesn't revert to the original dropdown selection?
Here is the code if it helps:

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)

OK wow that it perfect. I managed to play about and get it working but I only had it tied to when the checkbox was clicked, not actually undoing it if it was unchecked. Yours is soo much better!!

Thank you so much!!