VBA, , (Properties), . . , Value Range B3 Sales Current.xls:
Workbooks("current.xls").Worksheet("sales").Range("B3").Value=3
Bold Font B3 Sales :
Workbooks("current.xls").Worksheet("sales").Range("B3").Font.Bold =true
Excel Range ( ) , :
Font ;
Formula ;
Value ;
, .
, . , , :
.
, :
ActiveCell.Value
, . , , Application ActiveWindow, , . ActiveWindow, , Windows, ActiveCell, Range. , ActiveCell Font, , , Name,
Size Bold. , -, "" . :
ActiveWindow.ActiveCell.Font.Size
, , With .
Excel
Application
1. ActiveWindow
2. ActiveWorkbook
3. ScreenUpdating ( , )
4. StandardFont
Workbook ( Workbooks)
1. ActiveSheet
2. FullName ,
3. Name
4. Saved , ( False, )
|
|
Worksheet
1. Name
2. OnSheetActivate ,
3. Previous
4. ProtectContents
5. Visible ( )
: , ( ). , , , (=) :
. =
, , :
1. . , :
ActiveCell.Font.Size = 14
2. . . :
ActiveCell.Font.Name = "Courier New Cyr"
3. . , VBA True False, , . ( ):
ActiveCell.Font.Italic = True