: VBA, , ; VBA, .
VBA.
VBA - , , .
VBA 100 :
1. Application Excel, 120 40 , 400 : Application.().
2. Woorkbook , .
3. Woorksheet .
4. Range .
5. Selection , Select, Selection; Range.
6. Userform .
7. Chart .
( Collection) , , . , Workbooks Workbook ( ). , . VBA . . , .. , .
- . , , . , , .
, . .
: ..
, : Application.Quit.
, (, , , .). , , . .
: .=.
, F2:
Range("F2").Font.Colorindex=43
, (, ), . VBA , , - , .
1. F2 .
Range("F2").Select F2
With Selection.Interior
|
|
.ColorIndex = 7 , 1 56
.Pattern = xlSolid ( )
End With
Selection.Font.ColorIndex = 43 F2
2. ( ) .
With ActiveCell.Characters(Start:=1,Length:=5).Font
.Name = "Courier New"
.FontStyle = ""
.Size = 12
.Strikethrough = False ()
.Superscript = False ()
.Subscript = False ()
.OutlineFont = False
.Shadow = False ()
.Underline = xlUnderlineStyleNone
.ColorIndex = 43
End With
VBA.
VBA Visual Basic. VBA : , , , , , , , (. 11.1).
(View - Project Explorer) (Project Explorer). .
, , , . : ( , (Insert Module)) (, , , ).
(Insert UserForm), (Insert Module).
.11.1
, . , . , , (Procedure View), (Full Module View).
, . , . <Tab> . (Auto List Members) (Editor) - (Tools - Options).
, , , . (Auto Quick Info) (Editor) - (Tools - Options).
Enter, (Auto Syntax Check) (Editor) - (Tools - Options).
|
|