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 |
VBA
- , , - . , , . , , - "" ( , ). , - . , ( ) .
:
;
, , VBA ;
255 ;
. , ( : ). VBA;
. .. MyNumber, mynumber, mYnUmBeR.
, , . , , , , "AllSum".
VBA. VBA . . (=).
: Sum=120
120 , Sum.
. , VBA , Variant.
|
|
, , . .
, VBA . :
;
;
;
(.., "AllSumm", , allsumm, AllSumm)
Dim (Dimension).
:
Dim name1 [, name2]
: name N - .
- , , . , ( ), ( ).
:
Dim MyValue
Dim Value_1, Value_2
, , Variant.
VBA , ( " "):
;
- 0;
Boolean - False;
- 30 1899
. . , , , .
VBA, , , Variant, . :
;
, ;
;
, , ;
.
, . , - Dim.
Dim As , (. ).
:
Dim varname_1 [As type1] [, varname_2 [As type2]..]
Varname_N -
Type_N - VBA (. ).
, , , , , . .
|
|
, .. , , . , . . , , , , .
:
Dim varname As String * N
Varname -
N - ,
.
VBA, , , .
, , , , , , .
, VBA, .
, , . example_02 . VBA , .
, .
, VBA Option Explicit. Option Explicit VBA .
VBA
VBA, .
, , .
.
- (, , ), .
:
X = Y + 2
2 .
, , ( ) . , Pi ( 3,14), 3,14. , S = Pi * R* R "", S = 3.14 * R * R.
, , . "", .
, .. , , .
, .
String
(");
( " ") , ("");
.
VBA;
|
|
0 9;
(-) ;
;
.
Date
Date (#), :
#3-5-99#
#February 13, 2008 10:15am#
#Jun-20-2005#
# 9 April 1998#
VBA : #4/9/1998#
(#) , VBA ;
, .. VBA .
Boolean
Boolean: True, False. .
, .
Const
:
Const name_1 = value_1 [opetator name_2..] [, name_3 =..]
Name_N - ;
Value_N - ;
Opetator - .
, .. .
, , , . , .
, VBA , .
VBA ( ). Object Array. , Pi Single
Const Pi As Single = 3.14
- , VBA.
VBA host-. , Excel . , Word , Access - .
, VBA, vb. Excel - xl; Word - wd.
, host- VBA (, Excel, Word) , host-.
, Object Browser. F2 VBA.