Sub
Prüfung_1()
With
Worksheets(
"Sheet1"
)
If
.Range(
"BPK2"
).Value =
"x"
_
Then
Call
Prüfung_S_1
ElseIf
.Range(
"BPK3"
).Value =
"x"
_
Then
Call
Prüfung_S_2
ElseIf
.Range(
"BPK4"
).Value =
"x"
_
Then
Call
Prüfung_S_3
ElseIf
.Range(
"BPK5"
).Value =
"x"
_
Then
Call
Prüfung_S_4
ElseIf
.Range(
"BPK6"
).Value =
"x"
_
Then
Call
Prüfung_S_5
ElseIf
.Range(
"BPK7"
).Value =
"x"
_
Then
Call
Prüfung_S_6
ElseIf
.Range(
"BPK8"
).Value =
"x"
_
Then
Call
Prüfung_S_7
ElseIf
.Range(
"BPK9"
).Value =
"x"
_
Then
Call
Prüfung_S_8
ElseIf
.Range(
"BPK10"
).Value =
"x"
_
Then
Call
Prüfung_S_9
ElseIf
.Range(
"BPK11"
).Value =
"x"
_
Then
Call
Prüfung_S_10
Else
:
Call
Prüfung_2
End
If
End
With
End
Sub
Sub
Prüfung_2()
With
Worksheets(
"Sheet1"
)
If
.Range(
"BPK460"
).Value =
"x"
_
Then
Call
Prüfung_O_1
ElseIf
.Range(
"BPK461"
).Value =
"x"
_
Then
Call
Prüfung_O_2
ElseIf
.Range(
"BPK462"
).Value =
"x"
_
Then
Call
Prüfung_O_3
Else
:
Call
Ende
End
If
End
With
End
Sub