+ Reply to Thread
Results 1 to 2 of 2

Worksheet Checkboxes if row is not blank

  1. #1
    Registered User
    Join Date
    10-23-2012
    Location
    Washington, DC
    MS-Off Ver
    Excel 2010
    Posts
    43

    Worksheet Checkboxes if row is not blank

    I am working with a very large table with a range of $B$7:$G$16006 (with the headers in row 6) that is updated dynamically through sheet formulas.

    My issue is related with inserting a checkbox (Form control type) next to each row in cell $A7 if the formula in column C (second column in my table) does not result in a "" or "0".
    The formula I am working with is:

    Please Login or Register  to view this content.
    The problem with this is that 1) this takes forever to execute/freezes excel due to the number of table rows to loop through (16000) and 2) I cannot figure out how to incorporate the "LinkedCell" code needed to insert TRUE/FALSE in to the address cell of each checkbox.

    I have also been looking at "Marlett checkboxes" however cannot figure out how to create the code to only add the Marlett feature to a cell in column A if the row/cell in column C is not "" or "0":

    Please Login or Register  to view this content.
    Suggestion are greatly appreciated, apologies for the long post but I am trying to find the best approach!

  2. #2
    Registered User
    Join Date
    10-23-2012
    Location
    Washington, DC
    MS-Off Ver
    Excel 2010
    Posts
    43

    Re: Worksheet Checkboxes if row is not blank

    Update: went with the Marlett checkboxes, only needed to modify the If statement:
    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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