Hat mein Code zu viele & ?? oder wo kann sich das Problem verstecken ?
Der Code:
Private Sub CommandButton1_Click()
If ActiveSheet.ComboBox1 = "1" Then ActiveSheet.Shapes("Rechteck 3").Select& ActiveSheet.Shapes("Linie 33").Select
If ActiveSheet.ComboBox1 = "2" Then ActiveSheet.Shapes("Rechteck 2").Select& ActiveSheet.Shapes("Linie 32").Select
Selection.ShapeRange.ZOrder msoSendToFront
If ActiveSheet.ComboBox1 = "2" Then ActiveSheet.Shapes("Rechteck 3").Select& ActiveSheet.Shapes("Linie 33").Select
Selection.ShapeRange.ZOrder msoSendToFront
If ActiveSheet.ComboBox1 = "2" Then ActiveSheet.Shapes("Linie 66").Select
Selection.ShapeRange.ZOrder msoSendToFront
If ActiveSheet.ComboBox1 = "3" Then ActiveSheet.Shapes("Rechteck 2").Select& ActiveSheet.Shapes("Linie 32").Select
Selection.ShapeRange.ZOrder msoSendToFront
If ActiveSheet.ComboBox1 = "3" Then ActiveSheet.Shapes("Rechteck 3").Select& ActiveSheet.Shapes("Linie 33").Select
Selection.ShapeRange.ZOrder msoSendToFront
If ActiveSheet.ComboBox1 = "3" Then ActiveSheet.Shapes("Rechteck 4").Select& ActiveSheet.Shapes("Linie 34").Select
Selection.ShapeRange.ZOrder msoSendToFront
If ActiveSheet.ComboBox1 = "3" Then ActiveSheet.Shapes("Linie 66").Select
Selection.ShapeRange.ZOrder msoSendToFront
End Sub