VBA
V . , , Windows. VBA. . , , , . (Control Toolbox). , , , .
2.1
, , . . . , . , RefEdit, , . (Control Toolbox).
TextBox | ||
Label | ||
CommandButton | ||
ListBox | ||
ComboBox | ||
ScrollBar | ||
SpinButton | ||
OptionButton | ||
CheckBox | ||
ToggleButton | ||
Frame | ||
Image | ||
RefEdit | RefEdit | |
MultiPage |
(Control Toolbox) . , , . (. 2.2).
2.2
Excel , (Design Mode) (Control Toolbox). . . . 2.3 CommandButton () . , , , , (Design Mode).
|
|
2.3 CommandButton
(Properties) (Control Toolbox). (Properties)(. 2.4). (Properties) Visual Basic. Caption, . 2.4 aption CommandButton (CornmandButton1) . , Font, , , 8 12, MS Sans Serif Courier New . Shadow True, False, . Shadow , .
2.4 CommandButton
Caption, Font Shadow
, . . , . :
Click | |
DblClick | |
GotFocus | |
LostFocus |
. , , , (View Code) (Control Toolbox).
(View Code) 1, . . , , (. 2.5). , , . , .
2.5
, . (General), .
, .
Click , , ( ).
Private Sub Conimancffluttonl_Click()
|
|
MsgBox " "
End Sub