+ Reply to Thread
Results 1 to 5 of 5

When checkbox is checked it does not copy to new sheet. Only if not checked using false

  1. #1
    Registered User
    Join Date
    03-27-2013
    Location
    Long Island, NY
    MS-Off Ver
    Excel 2007
    Posts
    35

    Question When checkbox is checked it does not copy to new sheet. Only if not checked using false

    I want to copy the rows of checked boxes over onto a new sheet.
    The code works fine when I use False instead of True, but I would like to use True. When using True it does nothing, but using False it will copy them over. Any ideas? or can i not do that with this method?

    The below is using True which does not work. When the keyword is changed to False it works fine.
    Please Login or Register  to view this content.
    I have tried using
    Please Login or Register  to view this content.
    Please Login or Register  to view this content.
    to no avail.

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643
    Only had a quick look at the code but shouldn't it be just c.Value here?
    Please Login or Register  to view this content.
    If posting code please use code tags, see here.

  3. #3
    Registered User
    Join Date
    03-27-2013
    Location
    Long Island, NY
    MS-Off Ver
    Excel 2007
    Posts
    35

    Re: When checkbox is checked it does not copy to new sheet. Only if not checked using fals

    Norie,
    Thank you very much. That fixed it like a charm. I thought because it was a range I had to include it again. Thanks again!

  4. #4
    Registered User
    Join Date
    05-24-2013
    Location
    Vancouver, Canada
    MS-Off Ver
    Excel 2007
    Posts
    1

    Re: When checkbox is checked it does not copy to new sheet. Only if not checked using fals

    How about adding a column with a formula =IF(A1=TRUE,FALSE,TRUE) in the spreadsheet and just change the range in your code to that column?
    You can hide the one you don't need.

    Alternatively you may wanna try looking into the Marlett checkboxes. Here's a good example on those:
    http://www.vbaexpress.com/kb/getarticle.php?kb_id=879

  5. #5
    Registered User
    Join Date
    03-27-2013
    Location
    Long Island, NY
    MS-Off Ver
    Excel 2007
    Posts
    35

    Re: When checkbox is checked it does not copy to new sheet. Only if not checked using fals

    Quote Originally Posted by kapkan View Post
    How about adding a column with a formula =IF(A1=TRUE,FALSE,TRUE) in the spreadsheet and just change the range in your code to that column?
    You can hide the one you don't need.

    Alternatively you may wanna try looking into the Marlett checkboxes. Here's a good example on those:
    http://www.vbaexpress.com/kb/getarticle.php?kb_id=879
    Thanks, but I already found a perfect solution. That does not fit my entire application.

+ 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. If checkbox checked, cut row and paste on next sheet
    By BlueEyedLady in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-10-2014, 02:46 PM
  2. Replies: 2
    Last Post: 12-19-2012, 11:23 PM
  3. Copy values if checkbox is checked
    By jtone32512 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-21-2012, 03:54 AM
  4. Copy row data for checked checkbox
    By Christeen in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-09-2011, 09:50 PM
  5. copy if checkbox checked to sheet two
    By BillyRogers in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-28-2006, 04:35 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