View Single Post
 
Old 08-06-2019, 08:48 AM
jaffa20 jaffa20 is offline Windows 10 Office 2019
Novice
 
Join Date: Aug 2019
Posts: 4
jaffa20 is on a distinguished road
Default I will try and record macros for each one

Quote:
Originally Posted by NoSparks View Post
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
File Type: xlsm Quality Check Recorder.xlsm (36.2 KB, 5 views)
Reply With Quote