Wie kann ich das zusammenfassen?
If Target.Address(0, 0) = "B19" Then
UserForm7.ComboBox1 = Target(1)
UserForm7.Show
End If
If Target.Address(0, 0) = "B21" Then
UserForm7.ComboBox1 = Target(1)
UserForm7.Show
End If
If Target.Address(0, 0) = "B23" Then
UserForm7.ComboBox1 = Target(1)
UserForm7.Show
End If
Vielen Dank
Guenter