:
, , VB: \;
VB: \;
(. 16) , ( , );
. 17.
();
;
OK. () ( ), ();
(), , ;
7. , . . - .
: . , .
(). , , . . : , , , . . Visual Basic : ( ) , .
. .2 Visual Basic, .
2
Visual Basic
| t | 1 | 0 255 | |
| 1 | 2 | rue () False () | |
| Integer | 2 | -32768 32767 | |
| Long Integer | 4 | +/- 2.19 | |
| Single | 4 | -3.40282338 -1.401298-45 1.401298 -45 3.40282338 | |
| Double | 8 | -1. 79763 13486232308 -4.94065645841247-324 4.94065645841 247-324 1. 79763 13486232308 | |
| String ( ) | () | 1 | 1 65400 |
| String ( ) | () | 10 + 1 | 0 |
| Object | 4 |
. 2
|
|
|
| Variant | |||
| Variant | 16 , 22 + 1 | ||
| Decimal | 14 | 29 27 | |
| Date | 8 | 1 1000 . 31- 9999 . | |
| Currency | , 15 4 (. ) | 8 | -922337203685477.5808 922337203685477.5808 |
. . , :
[Static | Private | Public] Dim [ As ]
Dim () , Visual Basic, ; (, Visual Basic); As () , Visual Basic, ; ; Private (), Public () , ; Static () , , (, ) .
, Dim, Private, Public, Static. , ( , VBA - , Variant).
Option Explicit.
:
Dim x As Integer, M$, B&
Dim y As Integer
Option Explicit , , (Options) (Editor) (Require Variable Declaration). \ (Tools\Options).
Option Explicit, . , .
|
|
|
4
VBA
:
1. .
2. .
3. - .
4. MS Excel.
:
, f(x)=0, VBA, , : ) ; ) ; ) ; ) .
OptionButton, (UserForm). OptionButton Frame. (UserForm) ( Label ; TextBox , , ; CommandButton , () ). .
:
1. .
2. , (. . . 1).
3. ( ) .
4. (UserForm) .
5. - .
6. :
| f (x)=0 | ||||
7. .
8. .
9. .
