ich habe folgende Makros:
Private Sub OptionButton1_Click()
If OptionButton1.Value = True Then ActiveSheet.Cells(12, 11) = "Frau"
OptionButton2.Value = False
OptionButton3.Value = False
OptionButton4.Value = False
End Sub
Private Sub OptionButton2_Click()
If OptionButton2.Value = True Then ActiveSheet.Cells(12, 11) = "Herrn "
OptionButton1.Value = False
OptionButton3.Value = False
OptionButton4.Value = False
End Sub
Private Sub OptionButton3_Click()
If OptionButton3.Value = True Then ActiveSheet.Cells(12, 11) = "Eheleute"
OptionButton1.Value = False
OptionButton2.Value = False
OptionButton4.Value = False
End Sub
Private Sub OptionButton4_Click()
If OptionButton4.Value = True Then ActiveSheet.Cells(12, 11) = "Firma"
OptionButton1.Value = False
OptionButton2.Value = False
OptionButton3.Value = False
End Sub
wenn aber in K12 weder Frau, Herrn, Eheleute und Firma steht, sollen die Optinbutton alle deaktiviert sein.mfg wolfgang