| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need to sort based on Check Boxes
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Need to sort based on Check Boxes
Private Sub CheckBox1_Click()
If CheckBox1.Value = True Then MsgBox "checkbox selected" End If End Sub "Bill Mosserati" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Need to sort based on Check Boxes
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 -----Original Message----- Private Sub CheckBox1_Click() If CheckBox1.Value = True Then MsgBox "checkbox selected" End If End Sub "Bill Mosserati" wrote in message ... 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 . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| List sort - filter macro based on check box | Excel Discussion (Misc queries) | |||
| Hide & Show Rows based on Check Boxes | Excel Discussion (Misc queries) | |||
| Can one cell hold multiple check boxes (and then sort based off e. | Excel Discussion (Misc queries) | |||
| Can you sort with check boxes? | Excel Discussion (Misc queries) | |||
| How can I sort check boxes in excel? | Excel Worksheet Functions | |||
Linear Mode
