10
MS EXCEL
: MS Excel: , , , ; .
Microsoft Excel, . , Visual Basic. . , .
, , . : .
1.1.1 . Visual Basic Visual Basic. : , .
:
1) :
- Þ ;
- ;
- ;
- , .
2) Þ Þ (. 1.1).
3) (. . 1.1):
- . , . ; ;
- , , .. .
4) , (. . 1.1). Ctrl+ ( ) Ctrl+Shift+ ( ), . , @ #.
. Microsoft Excel , , .
1.1
5) , . Microsoft Excel, (. . 1.1).
6) , (. . 1.1).
7) OK.
8) , , . , . , Microsoft Excel , .
|
|
|
9) , .
10) .
Visual Basic, :
1) Þ Þ Visual Basic (. 1.2).
2) Insert Module.
3) .
4) , F5.
5) , File Þ Close and Return to Microsoft Excel.
1.1.2 . :
1) , , .
2) Þ Þ .
3) .
4) , .
5) .
1.2 Visual Basic
1.1.3 . :
1) .
2) , .
3) , .
4) , .
5) .
- Microsoft Excel: ; , ESC.
- Microsoft Visual Basic: ; Run Sub/UserForm.
: , Visual Basic, Macros Tools. Macro name , , Run.
1.1.4 . Visual Basic, Microsoft Excel.
1) .
2) Þ Þ .
3) .
4) .
1.1.5 . :
1) .
2) , , , , .
3) Þ Þ Visual Basic.
4) Þ .
5) .
MS Excel
, , . , , , . - , .
|
|
|
, - , . -. .
Microsoft Excel . ActiveX , Visual Basic (VBA) -.
ActiveX ActiveX. ( ), , . Visual Basic , .
1.2.1 . , ActiveX , . , ActiveX. , .
, , , . .
. 1.1 . 1.2 ActiveX .
1.1 ActiveX
| . . | |
| , . | |
| . | |
| , . | |
| . | |
| . . | |
| , . , . | |
| , . , . | |
| . , . | |
| , ActiveX, . | |
| ActiveX, . | |
| ActiveX. |
1.2
| , , . | |
| , . | |
| . . | |
| , . . | |
| . | |
| . - . | |
| . , . | |
| . , . |
|
|
|
1.2.2 . ( , ) . . .
, , . .
. Caption (. 1.3) .
1.3 Properties,
. Visual Basic . :
Private Sub CommandButton1_Click()
Call 1
End Sub
: 1 , , .
Excel 
. . .
2.1 _excel10.
2.2 .
2.3 (. ).
2.4 .
2.5 .
2- ( 0 10).
| 1. | Impact | , | ||||||
| 2. | Times New Roman | , | ||||||
| 3. | Verdana | , | ||||||
| 4. | Courier New | , | ||||||
| 5. | Impact | , | ||||||
| 6. | Times New Roman | , | ||||||
| 7. | Verdana | , | ||||||
| 8. | Courier New | , | ||||||
| 9. | Courier New | , | ||||||
| 10. | Times New Roman | , |
1) MS Excel?
2) MS Excel?
3) MS Excel?
4) MS Excel?
5) MS Excel?
6) ?
7) ?
|
|
|
8) ?
9) ?
