3
. , .
: .
: . , .
, . . . .
VBA VB .
, .
, . , 3.1.
|
| ||||||
. 3.1. -
:
If <> Then <1> [Else <2>]
: , End If.
( ), , 3.2.
. 3.2. -
.
:
If <> Then
<1>
<2>
<>
[Else
<A>
<B>
<N> ]
End If
Then Else . - , : ().
, , , Else .
, ( ).
|
|
. .
. 3.3. -
:
If <1> Then
<1>
<2>
<M>
ElseIf <2> Then
<A>
<B>
...
<N>
[Else
<I
<II
<K> ]
End If
ElseIf , .
, If Then Else End If, IIf, :
Znach = IIf( <>, 1, 2 )
Znach, , 1 2.
IIf , . :
Znach=IIf( <1>, 1, IIf( <2>,2,3 ))
.
VBA Select Case. . , . 3.4.
. 3.4. - ,
, .
Select Case :
Select Case <>
Case <1- >
1
Case <2- >
2
...
Case Else
N
End Select,
<> (, , , . .).
< > Case :
) :
Case 1: .1
Case 2, 3: .2
) :
Case 1 To 15 .1
Case 16 To 31 .2
) (=, <, >, <=, >=, <>)
Case Is < 15 .1
Case Is >=15 .2
, .
. :
;
;
.