VBA Select Entire Row if Checkbox AND Select Down Until Next Checkbox

I have a worksheet (see attached) with checkboxes linked to column Z to give a TRUE or FALSE. This code selects the rows if TRUE in column Z, and then I paste it elsewhere.

Please Login or Register  to view this content.

But what I'm trying to do is select a row if TRUE in column Z AND select the next rows as well until the next row with TRUE or FALSE. For example, in my sample workbook, I'd want to select 4:6 if F4 has a check and F7 doesn't. Does that make sense?


Thanks!!

Alphafrog, that gives me an error message ... "Unable to get the Checkboxes property of the Worksheet class."

Apparently this is because my checkboxes aren't ActiveX. So either I need to go back to the original idea of copying lines based on the TRUE or FALSE in column Z, or I need to modify the code I'm using to place the checkboxes to make them ActiveX. Any ideas on how to do either?

Please Login or Register  to view this content.

Looking back on it, the title probably wasn't the best description. I'm using checkboxes, but really I'm looking to copy the rows with TRUE in column Z, then copy all rows underneath that one until it reaches a row that is <> TRUE (so either "" or FALSE). Make sense?

Ok...I see what you did there. That's a cool trick, but it doesn't work for what I'm needing. It selects and copies only one group at a time, and I'll need it to do more than that. And instead of executing the code when they tick the box, I'd rather it happen when they push the "submit" button so that it copies multiple groupings.

I imagine that the users will usually select all, or they may only select one or two of them. So I need this code to be able to select multiple groups, and probably non-sequentially.

But thanks so much for helping me with this!

I was able to come to a 2 step solution. It feels a bit ratchet, but it works

Please Login or Register  to view this content.