.


:




:

































 

 

 

 


Visual Basic for Application Microsoft Office Excel.




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





:


: 2016-11-18; !; : 761 |


:

:

, .
==> ...

819 - | 739 -


© 2015-2024 lektsii.org - -

: 0.012 .