. VBA .
Sub < >()
End Sub
, :
Sub < > ()
< 1>
< 2>
< N>
End Sub
, :
CL (Click Left);
CR (Click Right);
DC (Double Click);
DD (Drag and Drop), : , , ( ) ( ).
:
Þ Þ Þ
, Visual Basic ,
Þ Þ Visual Basic
VBA
. () Excel. : Excel ( Þ ). .
Þ Þ Visual Basic
, VBA
() . Project
Insert Þ Module
, . Project Remove
.
1. , ,
Þ Þ
.
2. (Code)
View Þ Code
( < F7 >), (Project)
|
|
View Þ Project Explorer
( < R > <Ctrl >,
.. < Ctrl >+< R >).
, . ,
, , ;
;
, .
. , , sub . < Enter >, , , End Sub ( ).
:
, , . ,
a = 20: b = 2 * a
. . ,
If a > b Then d = a Else d = b
If a > b _
Then d = a _
Else d = b
, . , . / < Insert > ( < Ins >).
, , <Backspace>, <Delete>. <Ctrl>, .
( ), . (, , ) , <Ctrl>:
<Ctrl>+<←> ;
<Ctrl>+<→> ;
<Ctrl>+<↑> ;
<Ctrl>+<↓> ;
<Ctrl>+<Home> ;
<Ctrl>+<End> .