: MS Excel.
: Visual Basic. . .
: , , (.1) , .2.
1. , .1. "" .
.1
2. , .
2.1. 1 2, , , (.1) 1- 2- . , ( 1) G1:G2, ( 2) H1:H2. , 15 25 . ( ). , - . , 2 .
2.2. , (15:D35) .
3. () .
3.1. Visual Basic Alt+F11 Visual Basic Editor (VBE) :
Project Explorer, - Properties Window, . VBA, Excel. , Microsoft Excel Objects. Excel, (Modules) (Forms), .
3.2. 1, Modules. Modules 1.
3.3. , Visual Basic Insert - UserForm. UserForm1 ( Name) ( Caption), .
3.3.1. , (View Properties Window). . Caption, " ". Name, , .
|
|
3.3.2. , (BackColor) (StartUpPosition).
3.3.3. , F5 Run - Run Sub/UserForm, . VBE.
3.3.4. (Toolbox), , , View Toolbox, .
3.3.5. (CommandButton) .2. Format .
3.3.6. Caption, , .2
3.3.7. . , . - CommandButton1 , Click, .
Private Sub CommandButton1_Click()
End Sub
.2
3.3.8. 1 1 CommandButton1_Click ( , " ").
3.3.9. .3.3.7.-3.3.8 2 .
View Code View Object .
3.3.10. (F5).
3.3.11. Me. Hide. .
3.3.12. 1 (). "" ActiveX . Caption " ". UserForm1.Show. , 1 (). , "" " ". .
3.3.13. 1, 2 , 1. . , 1 :
Private Sub CommandButton1_Click()
1
End Sub
3.3.14. .