:
Visual Basic for Application (VBA)
: , VBA
:
:
1. VBA
2. , , , , ,
3.
4.
, , (), .
( : 10, 20, 35 ..) . , , : 1:, 400:, vivod: - .. . VBA ( ) .
. , ( ), . , , , :
= 5: $ = һ: rm = 1+exp
, :
1) REM: REM _
2) : _
VBA .
( ) VBA :
- ;
- (0-9);
- .
(+,-,*,:,= ..), (.,:;?) .
.
, .
, 1 40 , , .
( ) , . , , :
a% = 1.2: z$ = CONST P3 = 60, n% = 12
CONST _ =
, .
Visual Basic . Visual Basic . 255 . , , . . . : Print. , PrintIt.
|
|
Visual Basic 14- , . :
String - . $ . - $. 2 . .
Integer - 32768 + 32767. %. : %=5.
Long Integer - 2,15* 109 +2,15* 109. &. : &=1234567.
Single Precision - !. 7 . , 12345678.97 8.97 . , 12345670.01.
, . -3,4*1038 -1,4*10-45 1,4*10 45 3,4*1038 .
Double Precision - 16 300 . #. .
Currency - . 4 15 . . @.
Date - 1 100 31 9999 . #. - Millenium = # January 1, 2001#
Byte - 0 255. (1 ) .
Boolean - : True False.
Variant - . Visual Basic . Variant , .
. Dim, - . :
Dim A As Integer
.
Dim A As Integer, Name As Integer
:
Dim X, Y, Z As Integer
, . X Y Variant Z Integer. , . Variant, - Dim - AS. : Dim FOO.
. , Visual Basic , . Visual Basic , . , .
|
|
. Visual Basic . Visual Basic , . , Option Explicit.
Option Explicit General.
General :
1) Code
2) General Object
3) Declaration Procedure
4) Option Explicit.
- , . Visual Basic . , .
, Visual Basic , . , Option Explicit - Declaration
.
, VBA . , , .
VBA . - , Windows. , , , .
. , :
1. , , , .
2. /UserForm. .
3. VBA / . .
4. , , ( Name).
. , , . / .
, VBA , 10.1.
10.1