checklist

Hi all ive found a vba somewhere online where double clicking in a cell causes a tick to appear on any cell within a range (in my case I5:M32), but as I would use this VBA on a checklist, I would only want excel to allow one tick per row. If someone ticked I5 and then J5, the original tick in...

What I want to do is: If the checkbox in cell X1 is true then copy cell X2 and then paste in Cell X3 but only if Cell X4 is equal to todays date. If it's not todays date then check cell Y4 for todays date. If not then check cell Z4... And so on until the cell with todays date is found. So if...

I am trying to allow user to use a checklist in excel. When I protect the sheet, the checklist is also becomes locked and won't allow a user to modify. I have tried to unprotect the checklist object but it does not seem to make a difference when I limit the protection to just the cells in the...

I want a percent returned in Cell E2 after it looks through column E7:E287 and if the ActivX checkbox in that column is checked, I want it to increase the completion percentage in Cell E2. What is the formula that I would use for this?

Hi, I am researching companies and tracking my research using an excel spreadsheet. I've created a rubric rating a company 1-5 with 5 being the highest rated/i.e. best potential sale. Each of the following items is rewarded with one point for each of the following. 1. High need of paper...

Hi Mr. Excel, I'm using Excel 2007 and Windows XP. 1. General Question: How to create a madro to perform common "print set up" procedures. (Every time we print a "Checklist" we have to follow a series of steps... is it possible to have a macro do this?) 2. Background Info: a. To update...