+ Reply to Thread
Results 1 to 11 of 11

Adding Checkboxes Updating Formula

Hybrid View

  1. #1
    Forum Expert Arkadi's Avatar
    Join Date
    02-13-2014
    Location
    Smiths Falls, Ontario, Canada
    MS-Off Ver
    Office 365
    Posts
    5,059

    Re: Adding Checkboxes Updating Formula

    Lets see if this works... instead of formulas the code does the listing, and kept jeffreybrown's great checkmark code, just expanded to use any columns defined in an array at the start

    I also made it more dynamic, so you can go to any row and the code should be good. (listing and double-clicking will work up to last row of the column it belongs with). So if last row in Col A that has data is row 40 then B and C will also work for clicking up to row 40.
    Last edited by Arkadi; 06-07-2018 at 01:50 PM.
    Please help by:

    Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
    Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know

    There are 10 kinds of people in this world... those who understand binary, and those who don't.

+ 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. Macro for adding VBA checkboxes
    By steve_l in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-23-2011, 06:45 AM
  2. updating formula when adding a new workbook
    By bmunoz64 in forum Excel General
    Replies: 3
    Last Post: 12-20-2010, 05:07 PM
  3. Adding Values to Checkboxes
    By gtwinter in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-05-2010, 03:40 PM
  4. Replies: 0
    Last Post: 06-05-2009, 02:17 PM
  5. [SOLVED] Adding Checkboxes to a Form
    By Bill in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-26-2006, 07:00 PM
  6. adding checkboxes
    By shadespool in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-17-2006, 01:46 PM
  7. Adding checkboxes via code to a workheet
    By Stef in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-01-2005, 11:06 AM
  8. Checkboxes for adding values
    By traps in forum Excel General
    Replies: 0
    Last Post: 01-06-2005, 12:07 AM

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