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.

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!

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

Originally Posted by kapkan

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.