:
: VBA. .
( ) G, :
GoTo
(0, 1, 2,...) , (, st53).
, ( ), . ϳ , , G. , ().
GoTo , . , GoTo.
GoTo For...Next, For Each...Next, SyncLock... End SyncLock, Try... Catch... Finally, With... End With Using... End Using .
. .
, . 䳿, . (.1)
1 -
Visual Basic:
If Then
If . True, . False, 䳿 .
1:
Public Sub PR1()
Dim X As Integer
X = 12
2: If X > 9 And X < 12 Then GoTo LastLine
X = X 2
GoTo 2
LastLine:
MsgBox (X)
End Sub
(.2) :
If Then 1
Else ij2
End If
2 -
If . True, 1. False, 2.
2: , 8. ( ), ( ). k, l, m, n. (k, l) . , , (m, n).
:
...
|
|
. , , True False. , . , 璺 And, Or, Not.
3: . , , .
ϳ , , . : (.3).
3 -
Visual Basic :
If 1 Then 1
ElseIf 2 Then ij2
Else ij3
End If
-:
= IIf(, 1, 2)
, 1 2 , . IIf 1 2 , ru False.
4:
Public Sub IT4()
+++
=IIf(Mx<0, 1,-1).
', .
, , . .
Visual Basic :
Select Case TestValue
Case Value 1
ij 1
...
Case Value N
ij N
Case Else
ij N+1
End Select
TestValue , . , , , .
Value 1 Value N .
ϳ TestValue Value k. Case . , , Case Else.
5: . : , , , , , 쳿, , , , , . , .
5: