4. .
:
1. ( ):
2.
- " , ";
- CalcRC;
- " R ":
2. CalcRC .
3. ( . 2 VBA( ).
5. .
:
1. ", " "F", "F", . (, / /// F), .
2. "F" ", ". .
()
6. .
:
1. MsgBox, (5 ), (4 ), .
2. .
/ | ||
VbOkOnly | MsgBox("!", vbOKOnly)=vbOk | |
VbOkCancel | MsgBox ("!", vbOKCancel)=vbOk | |
VbAbortRetryIgnore | MsgBox ("!", VbAbortRetryIgnore)=vbAbort | |
VbYesNoCancel | MsgBox("!", VbYesNoCancel)=vbYes | |
VbYesNo | MsgBox ("!", vbYesNo)=vbYes | |
VbRetryCancel | MsgBox ("!", VbRetryCancel)=vbretry | |
VbCritical | MsgBox("!", vbCritical)=vbYes | |
VbQuestion | MsgBox("!", VbQuestion)=vbYes | |
VbExclamation | MsgBox("!", VbExclamation)=vbYes | |
VbInformation | MsgBox("!", vbInformation)=vbYes |
3. . 2 VBA( ) ( 10 ).
4. .
( )
7. () Excel.
:
1. ( ):
, 2001-2002
, . . 201927
, . . 155891
, . . 102279
2. _ .
|
|
3. - , , , " ".
4. ( .. 1).
5. . Excel: , .
6. . 2 VBA - .
VBA:
. 2 VBA - ( F , );
. 2 VBA - ;
. 2 VBA - .
1. ?
2. ?
3. VBA?
4. VBA, ?
5. VBA?
6. Word ( .txt .doc)?