I have a userform with 6 checkboxs, all, mon, tue, wed, thur, fri, sat. I want the user to be able to pick which date(sheet) to choose to run certain code on. This is what I have but it doesn't work right.
Private Sub CommandButton1_Click()
If all.Value = True Then
Clear Ranges in all sheets
Else
If mon.Value = True Then
'Clear Ranges on Sheets 1 & 2
If tue.Value = True Then
'Clear Ranges on Sheets 3 & 4
Else
If thur.Value = True Then
'Clear Ranges on Sheets 5 & 6
Else
If fri.Value = True Then
'Clear Ranges on Sheets 7 & 8
Else
If sat.Value = True Then
'Clear Ranges on Sheets 1 & 2
Else
End If
End Sub
Private Sub CommandButton1_Click()
If all.Value = True Then
Clear Ranges in all sheets
Else
If mon.Value = True Then
'Clear Ranges on Sheets 1 & 2
If tue.Value = True Then
'Clear Ranges on Sheets 3 & 4
Else
If thur.Value = True Then
'Clear Ranges on Sheets 5 & 6
Else
If fri.Value = True Then
'Clear Ranges on Sheets 7 & 8
Else
If sat.Value = True Then
'Clear Ranges on Sheets 1 & 2
Else
End If
End Sub