Need to sort based on Check Boxes

B

Bill Mosserati

Is there a way to sort a spreadsheet based on checkboxes?
How do I get it to recognize that a box has been checked?

TIA,

BMosserati
 
D

David Adamson

Private Sub CheckBox1_Click()
If CheckBox1.Value = True Then
MsgBox "checkbox selected"

End If

End Sub
 
B

Bill Mosserati

David,

Thanks. May I pick your brain a bit more? If my
spreadsheet is dynamic, is there a way to code this to
adjust as new rows are added/deleted? Once the
appropriate boxes are selected, can I code a function to
sort/filter based on those that are checked and those that
are not?

Bill
 
Top