Need to sort based on Check Boxes

  • Thread starter Thread starter Bill Mosserati
  • Start date Start date
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
 
Private Sub CheckBox1_Click()
If CheckBox1.Value = True Then
MsgBox "checkbox selected"

End If

End Sub
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem sorting a range of columns using VBA 1
How to parse text in a cell 8
sumif wildcard for text and numbers 2
Remove specific cells in a column. 2
Excel - Macro to rearrange/add columns in all the sheets based oncolumn header 10
Check Boxes 1
Code to display a true or false value in the cell containing a check box 1
help needed 1

Back
Top