VBA - Sort by checked checkboxes and print

[Jasesair]

I have data in range A6:K203. Column K contains checkboxes. My end result is wanting a printpreview of the range but only to show rows where column K contains checked checkboxes..

My thinking was to sort by column K somehow and then print the range down to the last row that's checked. Does anyone know how to do this? Or perhaps there's a better method???

 

[Yongle]

One option ...
- link the checkboxes to a cell in the same row in a new (possibly hidden) column in your data and then filter on that

 

[Jasesair]

I have this happening actually. The full range (to include the links) is A6:P203. Headings are in row 5. The checkboxes linked to Column K are in Column M, which are hidden. My attempts so far to sort have thrown the checking in the checkboxes all out. Any help with this would be much appreciated.

 

[Yongle]

Perhaps ...

 

[Jasesair]

Apologies. I mean that my attempts at sorting with VBA have failed. The correct checked checkboxes shift and aren't attached to the correct people etc in the other columns within the range. I'm a bit new to VBA and so I'm still learning on-the-fly.

 

[mikerickson]

Perhaps ...

View attachment 32973

In my testing "move but don't size with cells" results in checkboxes piling on top of other checkboxes when rows are hidden.

In situation where rows will be hidden or filtered, I prefer turning cells into Marlett checkboxes rather than using inserted controls.
Putting this code in the sheet's code module and double clicking on a cell in coulmn K will make each cell act as a checkbox.

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
    With Target
        If .Column = 11 Then
            Cancel = True
            If .Value = "a" Then
                .Value = vbNullString
            Else
                .Value = "a"
                .Font.Name = "Marlett"
            End If
        End If
    End With
End Sub

 

[Jasesair]

I'd prefer to keep the checkboxes as is (one click to check and uncheck). I'm just wanting a way to do a print of the range where column M is True.

 

[mikerickson]

Filter column M on True and print.

 

[Jasesair]

Would you have macro for this? My attempts failed miserably. I had tried sorting.