VBA Excel ()
: Excel ; VBA Excel. (. . , UDF User Defined Function).
ֳ: () Excel UDF- Excel .
/ :
Visual Basic Editor. . . ( , ). , . . . VBA Excel.
:
1) Visual Basic:
,
,
(, , ),
Edit (), Debug (), Tools (),
,
( , , );
2) , :
- , Variant, Variant,
- Dim, ,
- ,
- ,
- Option Explicit,
- , .. ;
3) ( ):
- if... Then... Else...,
- Select Case,
- With... End With,
- GoTo, , ,
- Do... Loop,
- While... Wend,
- For... Next,
- For Each... Next,
- With... End With,
- ,
- , ' .
4) VBA InputBox / MsgBox.
I. ( )
1. ( . 3).
2. ( , ).
3. (. 1):
- ;
- ;
- , : a) ( , Excel; ` , , ` VBA), b) ;
|
|
- : a) , b) , c).
4. .
5. ˳ (>1 ).
. , ( ).
II.
(.)
1
³ (. .3.2.2) :
a) . , . , ( ).
b) Sub, Excel . , . , ( ). VBA InputBox ( host- InputBox) / MsgBox. .
) , , A || || 1, || Excel. || || , || || .
1
1.
AveDev Excel
2.
Average Excel
3.
Ceiling Excel
4.
Search Excel
5.
Count Excel
6.
CountA Excel
7.
CountBlank Excel
8.
CountIf Excel
9.
Days360 360 Excel
10.
Small Excel
11.
Roman Excel
12.
DevSo Excel
13.
Even Excel
14.
Fact Excel
15.
Find Excel
16.
Fixed Excel
17.
Floor Excel
18.
Large Excel
19.
Odd Excel
20.
Permut Excel
21.
SumX2My2 Excel
22.
Rank Excel
23.
Combin Excel
24.
Covar Excel
25.
Forecast Excel
26.
GeoMean Excel
27.
HarMean Excel
28.
Intercept Excel
29.
Kurt Excel
30.
Db Excel
31.
|
|
Ddb Excel
2
³ (. .3.3.2) :
a) VBA - Function .
b) .