VBA Issues surronding Check Boxes on To Do List

**aboll** · 07-30-2014, 03:59 PM

I am fairly new to VBA codes and have been trying for days to get this spreadsheet to accomplish the end results I would like. I have a few questions and need some direction on a few things surrounding the check boxes. The desired function of this spreadsheet is to be able to keep track of tasks current and completed.

- When checking a box (column B) I would like the date the box was checked to appear in the date completed column (Column J). I've been able to format other changes (row color) if the box is checked but no luck with date.

- The ability to move checked rows to another tab (Not Immediately) but at least once a month. Is this feasible?

- A formula to accurately calculate the "Percent Complete" chart based off the amount of current tasks checked off in column B and content filled in C instead of a set number in a formula (inaccurate).

Any guidance, added suggestions, or help regarding these issues would be greatly appreciated!!!!to do.xlsm

**Tinbendr** · 07-31-2014, 09:35 AM

When checking a box (column B) I would like the date the box was checked to appear in the date completed column (Column J)

You just had wrong column assigned.

Please Login or Register  to view this content.

The ability to move checked rows to another tab

Just the data, correct?

A formula to accurately calculate the "Percent Complete"

Working on this one.

**aboll** · 07-31-2014, 10:24 AM

When entering that code it shows "Set cBox = ActiveSheet.CheckBoxes(LName)" as an error that needs de-bugged. Am I doing something wrong?? And yes the ability to move a checked row of data to another tab once a month if possible. Thank You so much!

**Tinbendr** · 07-31-2014, 10:51 AM

You probably don't have the right macro assigned to the checkbox. Right click the checkbox and select Process_CheckBox.

Here's the code for calculating the open tasks.

Add UpdateChart to the bottom of Process_CheckBox.

Please Login or Register  to view this content.

**Tinbendr** · 07-31-2014, 02:16 PM

OK, there is the completed version.

There are some problems with your checkboxes. There are five places where there are two checkboxes on top of each other. It was preventing the checkbox from clearing. If you can use this workbook, it will be easier than trying to find those again. (It was row 64, 65, 94, and I can't remember the other two)

All code is in Module 1.