.


:




:

































 

 

 

 





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.





:


: 2016-11-24; !; : 661 |


:

:

, , 1:10
==> ...

957 - | 915 -


© 2015-2024 lektsii.org - -

: 0.05 .