View Single Post
 
Old 08-06-2019, 05:39 AM
jaffa20 jaffa20 is offline Windows 10 Office 2019
Novice
 
Join Date: Aug 2019
Posts: 4
jaffa20 is on a distinguished road
Default Trying to tie checkboxes in one sheet of an excel doc to a table of specific customers in another

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!
Reply With Quote