sparkytech
Board Regular
- Joined
- Mar 6, 2018
- Messages
- 96
- Office Version
- 365
- 2019
I have a UserForm with checkboxes (Field Complete, In-Service, Started, Future), and need help to perform the following: a user can select one or more of these color checkboxes, and click the "Apply Filter" button which will then filter the sheet by font color(s) in each row. Future = black, Started = green, In-Service = blue, Field Complete = grey.
I also have a "Clear Color Filter" button that I need to clear these color filters, but nothing else. Can someone please guide me? Thanks!
I also have a "Clear Color Filter" button that I need to clear these color filters, but nothing else. Can someone please guide me? Thanks!
VBA Code:
Private Sub CheckBox1_Click()
'Future check box
End Sub
Private Sub CheckBox2_Click()
'Started check box
End Sub
Private Sub CheckBox3_Click()
'In-Service
End Sub
Private Sub CheckBox4_Click()
'Field Complete check box
End Sub
Private Sub CommandButton1_Click()
'Apply Filter button
End Sub
Private Sub CommandButton2_Click()
'Clear Filters button
End Sub
Private Sub CommandButton3_Click()
'Cancel button
blnCancel = True
Me.Hide
End Sub