Private Sub Worksheet_Activate()
With ComboBox1
.AddItem ""
.AddItem "ja"
.AddItem "nein"
.MatchRequired = True
End With
End Sub
Private Sub Worksheet_Activate()
With ComboBox1
.Clear
.AddItem ""
.AddItem "ja"
.AddItem "nein"
.MatchRequired = True
End With
End Sub
Gruß Jens