22-------------------
23. - , , .
- , , .
.
1. - .
2. - .
3. - .
4. -
1. - , () , , , .
2. - , () - .
3. - , .
( ) , ( , ), , , .
: : (1 ), 90 ( ) - . .
(1 ), 90, (1 ),
90, 90, 90,
(1 ), 90, (1 )
1. - ( ).
2. - ( ).
3. - ().
- , .
- .
-
25. ,
.
, .
- .
- .
: , , -,
26. VBA
27. VBA.
|
|
VBA ( ): Byte, Integer, Long, Single, Double, Currency.
:
- Byte - (: 0 - 255, - 1 );
- Integer - (-32768 - 32767, 2 );
- Long - (-2.1E9 - 2.1E9, 4 ).
:
- Single - (: -3,402823E38 - -1,401298E-45 1,401298E-45 - 3,402823E38, 4 );
- Double - (-1,79769313486232E308 - -4,94065645841247E-324 4,94065645841247E-324 - 1,79769313486232E308, 8 ).
Currency - , 15 (-922337203685477,5808 - 922337203685477,5807).
:
- string - 1 65400, 1 ;
- string - 0 2 . , 10 + .
Boolean - ( : True - False, 2 ).
Date - ( 1 100 31 9999 , 8 ).
Object - , ( , 4 ). - .
, VBA, , , , Variant.
Variant
- Variant () - ( , 16 );
- Variant () - ( 22 + ).
VBA.
28. VBA.
, , , . VBA :
- (0-9);
- (A-Z, a-z);
- (-, -);
- :!, @, #, $, %, &;
- .
VBA. .
. :
- ! - Single - ( );
- @ - Currency - ;
- # - Double - ;
- $ - String - ;
- % - Integer - ;
- & - Long - ( , ).
. :
- ;
- (_);
- ;
- .
(+,-,*,/,',",.,=,<,>,:) .
VBA :
|
|
- ();
- () ;
- ;
- .
() - , 255 , . . . .
: SalesHistory; intCount; _% ..
- , ("..."). , , , " "" "".
. . (.). .
() - , , . . , . , , . , - .
VBA , .
Byte
0 255
Boolean
: True, False
Currency
-922337203685477,5808 922337203685477,5807
Date
.
1.01.100 31.12.9999
00:00:00 23:59:59
Double
-1,79769313486232*10308 -4,94065645841247*10-324
4,94065645841247*10-324 1,79769313486232*10308
Integer
-32768 32767
Long
-2147483648 2147483647
Single
-3,402823*1038 -1,401298*10-45
1,401298*10-45 3,402823*1038
String
2 .
Variant