, .. Sub Function, Private Public, :
- Private: , ;
- Public: , , .
, (.. , Public). , .
.
1. . , . . , , . .
2. . , . ( , ) .
3. : ( a) (b), . b a (.. , ). . .
4. . , , . ( , ) .
5. . , . , , , . .
6. . : , , , . .
7. . . , , . , . , , , . .
|
|
8. sh x ( ) : . x, . ( , ).
9. ( a) s. a(1,1) s. a(1,1) > s, . 2x2 a. s, 3x3, .., , s. , a, . , s. s a, .
10. a, , 100. : g ( 100) k ( ). a, g. k, ; , g, . g 0,5, . , g, .
11. a, s. ( , , ). s, ; a . , , , . , .
12. y = f (x) [ a, b ] . [ a, b ] k d =(b - a)/ k, .. x 0 = a, x 1 = a + d, x 2= a +2 d, , xk -1 = a +(k -1) d. y : y 0 = f (x 0), y 1 = f (x 1), , yk -1 = f (xk -1). (y 0+ y 1++ yk -1) d. k , . , k . . (a b), . k (, k =2). .
|
|
13. f(x) = 0 [ a, b ] . a b , f(a) f(b) . c = (b + a)/2, f (c). , , (c ). [ a, b ] . , f (x) , . sin x / x = 0 . (a b), . .
14 ( a b), , a b ( , ). c. a; b, b(1), , a b. . c.
.
1. VBA?
2. IDE ( VBA)?
3. VBA?
4. VBA.
5. , .
6. - VBA.
7. VBA.
:
.
2. .
3. .
4. (, , ).
5. ( ).
6. ( , . .).
7. .
1. . . VBA. / . . . .: -, 2003. 512.
2. . . Visual Basic for Applications: . / .., .. .: , 2004. 176 .
3. .., .. Visual Basic for Application MS Office. : - . . . -, 2010. 104 .
4. .. Visual Basic for Applications. .: - Ȼ, 2012. 60 .