+ Reply to Thread
Results 1 to 5 of 5

VBA Issues surronding Check Boxes on To Do List

  1. #1
    Registered User
    Join Date
    07-29-2014
    Location
    London, England
    MS-Off Ver
    2007
    Posts
    2

    VBA Issues surronding Check Boxes on To Do List

    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

  2. #2
    Forum Expert Tinbendr's Avatar
    Join Date
    06-26-2012
    Location
    USA
    MS-Off Ver
    Office 2010
    Posts
    2,124

    Re: VBA Issues surronding Check Boxes on To Do List

    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.
    David
    (*) Reputation points appreciated.

  3. #3
    Registered User
    Join Date
    07-29-2014
    Location
    London, England
    MS-Off Ver
    2007
    Posts
    2

    Re: VBA Issues surronding Check Boxes on To Do List

    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!

  4. #4
    Forum Expert Tinbendr's Avatar
    Join Date
    06-26-2012
    Location
    USA
    MS-Off Ver
    Office 2010
    Posts
    2,124

    Re: VBA Issues surronding Check Boxes on To Do List

    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.

  5. #5
    Forum Expert Tinbendr's Avatar
    Join Date
    06-26-2012
    Location
    USA
    MS-Off Ver
    Office 2010
    Posts
    2,124

    Re: VBA Issues surronding Check Boxes on To Do List

    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.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 0
    Last Post: 06-27-2014, 04:16 PM
  2. I need a code for presence check to check multiple text boxes and combo boxes
    By Lee_wwfc in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-24-2013, 01:53 PM
  3. Add check boxes to a looong list of data
    By roplet in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-23-2011, 10:00 AM
  4. List of Check Boxes with MACROS
    By abamasd in forum Excel General
    Replies: 2
    Last Post: 03-23-2010, 03:40 AM
  5. Check boxes or List boxes?
    By NickH in forum Excel General
    Replies: 3
    Last Post: 03-17-2008, 02:56 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1