Checkbox-abfrage optimieren
14.12.2007 13:52:00
marion
kann mir jemand dabei helfen den folgenden code zu optimieren.
Es ist eine Checkbox-abfrage. Sicher etwas unelegant, aber wie geht es besser?
Checkbox3 - 14 wird abgefragt um den Monat zu ermitteln.
für jede Hilfe bin ich dankbar
Marion
Private Sub CheckBox3_Click()
If CheckBox3 Then
CheckBox4.Value = False
CheckBox5.Value = False
CheckBox6.Value = False
CheckBox7.Value = False
CheckBox8.Value = False
CheckBox9.Value = False
CheckBox10.Value = False
CheckBox11.Value = False
CheckBox12.Value = False
CheckBox13.Value = False
CheckBox14.Value = False
wahlmonat = 1
Range("A1").Select
ActiveCell.FormulaR1C1 = "Jan-" & Cells(2, 1)
Cells(3, 1) = wahlmonat
End If
End Sub
Private Sub CheckBox4_Click()
If CheckBox4 Then
CheckBox3.Value = False
CheckBox5.Value = False
CheckBox6.Value = False
CheckBox7.Value = False
CheckBox8.Value = False
CheckBox9.Value = False
CheckBox10.Value = False
CheckBox11.Value = False
CheckBox12.Value = False
CheckBox13.Value = False
CheckBox14.Value = False
wahlmonat = 2
Range("A1").Select
ActiveCell.FormulaR1C1 = "Feb-" & Cells(2, 1)
Cells(3, 1) = wahlmonat
End If
End Sub
Private Sub CheckBox5_Click()
If CheckBox5 Then
CheckBox3.Value = False
CheckBox4.Value = False
CheckBox6.Value = False
CheckBox7.Value = False
CheckBox8.Value = False
CheckBox9.Value = False
CheckBox10.Value = False
CheckBox11.Value = False
CheckBox12.Value = False
CheckBox13.Value = False
CheckBox14.Value = False
wahlmonat = 3
Range("A1").Select
ActiveCell.FormulaR1C1 = "Mar-" & Cells(2, 1)
Cells(3, 1) = wahlmonat
End If
End Sub
Private Sub CheckBox6_Click()
If CheckBox6 Then
CheckBox3.Value = False
CheckBox4.Value = False
CheckBox5.Value = False
CheckBox7.Value = False
CheckBox8.Value = False
CheckBox9.Value = False
CheckBox10.Value = False
CheckBox11.Value = False
CheckBox12.Value = False
CheckBox13.Value = False
CheckBox14.Value = False
wahlmonat = 4
Range("A1").Select
ActiveCell.FormulaR1C1 = "Apr-" & Cells(2, 1)
Cells(3, 1) = wahlmonat
End If
End Sub
Private Sub CheckBox7_Click()
If CheckBox7 Then
CheckBox3.Value = False
CheckBox4.Value = False
CheckBox5.Value = False
CheckBox6.Value = False
CheckBox8.Value = False
CheckBox9.Value = False
CheckBox10.Value = False
CheckBox11.Value = False
CheckBox12.Value = False
CheckBox13.Value = False
CheckBox14.Value = False
wahlmonat = 5
Range("A1").Select
ActiveCell.FormulaR1C1 = "May-" & Cells(2, 1)
Cells(3, 1) = wahlmonat
End If
End Sub
Private Sub CheckBox8_Click()
If CheckBox8 Then
CheckBox3.Value = False
CheckBox4.Value = False
CheckBox5.Value = False
CheckBox6.Value = False
CheckBox7.Value = False
CheckBox9.Value = False
CheckBox10.Value = False
CheckBox11.Value = False
CheckBox12.Value = False
CheckBox13.Value = False
CheckBox14.Value = False
wahlmonat = 6
Range("A1").Select
ActiveCell.FormulaR1C1 = "Jun-" & Cells(2, 1)
Cells(3, 1) = wahlmonat
End If
End Sub
Private Sub CheckBox9_Click()
If CheckBox9 Then
CheckBox3.Value = False
CheckBox4.Value = False
CheckBox5.Value = False
CheckBox6.Value = False
CheckBox7.Value = False
CheckBox8.Value = False
CheckBox10.Value = False
CheckBox11.Value = False
CheckBox12.Value = False
CheckBox13.Value = False
CheckBox14.Value = False
wahlmonat = 7
Range("A1").Select
ActiveCell.FormulaR1C1 = "Jul-" & Cells(2, 1)
Cells(3, 1) = wahlmonat
End If
End Sub
Private Sub CheckBox10_Click()
If CheckBox10 Then
CheckBox3.Value = False
CheckBox4.Value = False
CheckBox5.Value = False
CheckBox6.Value = False
CheckBox7.Value = False
CheckBox8.Value = False
CheckBox9.Value = False
CheckBox11.Value = False
CheckBox12.Value = False
CheckBox13.Value = False
CheckBox14.Value = False
wahlmonat = 8
Range("A1").Select
ActiveCell.FormulaR1C1 = "Aug-" & Cells(2, 1)
Cells(3, 1) = wahlmonat
End If
End Sub
Private Sub CheckBox11_Click()
If CheckBox11 Then
CheckBox3.Value = False
CheckBox4.Value = False
CheckBox5.Value = False
CheckBox6.Value = False
CheckBox7.Value = False
CheckBox8.Value = False
CheckBox9.Value = False
CheckBox10.Value = False
CheckBox12.Value = False
CheckBox13.Value = False
CheckBox14.Value = False
wahlmonat = 9
Range("A1").Select
ActiveCell.FormulaR1C1 = "Sep-" & Cells(2, 1)
Cells(3, 1) = wahlmonat
End If
End Sub
Private Sub CheckBox12_Click()
If CheckBox12 Then
CheckBox3.Value = False
CheckBox4.Value = False
CheckBox5.Value = False
CheckBox6.Value = False
CheckBox7.Value = False
CheckBox8.Value = False
CheckBox9.Value = False
CheckBox10.Value = False
CheckBox11.Value = False
CheckBox13.Value = False
CheckBox14.Value = False
wahlmonat = 10
Range("A1").Select
ActiveCell.FormulaR1C1 = "Oct-" & Cells(2, 1)
Cells(3, 1) = wahlmonat
End If
End Sub
Private Sub CheckBox13_Click()
If CheckBox13 Then
CheckBox3.Value = False
CheckBox4.Value = False
CheckBox5.Value = False
CheckBox6.Value = False
CheckBox7.Value = False
CheckBox8.Value = False
CheckBox9.Value = False
CheckBox10.Value = False
CheckBox11.Value = False
CheckBox12.Value = False
CheckBox14.Value = False
wahlmonat = 11
Range("A1").Select
ActiveCell.FormulaR1C1 = "Nov-" & Cells(2, 1)
Cells(3, 1) = wahlmonat
End If
End Sub
Private Sub CheckBox14_Click()
If CheckBox14 Then
CheckBox3.Value = False
CheckBox4.Value = False
CheckBox5.Value = False
CheckBox6.Value = False
CheckBox7.Value = False
CheckBox8.Value = False
CheckBox9.Value = False
CheckBox10.Value = False
CheckBox11.Value = False
CheckBox12.Value = False
CheckBox13.Value = False
wahlmonat = 12
Range("A1").Select
ActiveCell.FormulaR1C1 = "Dec-" & Cells(2, 1)
Cells(3, 1) = wahlmonat
End If
End Sub