Visual Basic.
Microsoft Excel, :
, .
.
, .
.
Visual Basic ( VB), (. 3.1). , .
.3.1
:
) ;
) .
Visual Basic, . . , , , . , . , , .
:
. . .
. , . .
.
Visual Basic (VB)
Visual Basic (VB) , Visual Basic Windows. VBA , . VBA , - . . , VBA.
Visual Basic . , , . Visual Basic .
|
|
Visual Basic , , . . , , .
Visual Basic - . , , , .., . , , . Visual Basic , .
VBA . , , , . .
. , - . , Visual Basic , , .
VBA Microsoft Excel , , . , , . Visual Basic . -, , , Excel. Application Excel (Menu), (Control), (Workbook) .. - ( , , , ..), - (Range). . Microsoft Office.
Visual Basic , .., . , Excel 5 3 1 ( ):
Application. Workbooks ( 1).Worksheet (3). Range (5)
. , Visual Basic Excel Range, Range. . , Excel Worksheet. , Sheets, ( , , , ) .
|
|
. , . , , . , . , Color , 0 , 1 , 2 , 3 , 4 , 5 .. VBA Microsoft Office , ; .
, , , . :
object.property
: object , ;
property .
, Excel Formula ( ) 5 ABS(B4), 1 2, :
Workbook(2).Worksheet(1).Range(5).Formula = ABS(B4)
y Formula :
My Formula =
Workbook(2).Worksheet(1).Range(5).Formula
, .
Visual Basic , , . , Range Calculate , Clear . , , . , .
, . , , , , , .
, Excel Rows , . RowHeight 20, :
Selection.Rows.RowHeight = 20
Rows Count :
NumRows = Selection.Rows.Count
, , Rows Rows. , . RowHeight Rows, :
TheHeight = Selection.Rows(2).RowHeight
, , . , Insert Range , . Insert :
|
|
Selection.Insert xlDown
, , . .
Visual Basic :
1. , .
2. , .
Visual Basic . Windows , , . , ( ), .
, Windows, , , . :
File, , .
Edit, , , .
Help, .
, , .
, . Visual Basic. , , .
( , , , -) . , , .
, . . , .
Visual Basic - , , .
. , . Visual Basic - VB , .
Visual Basic :
1. .
2. .
Visual Basic , . , Click ( ). , Click, , .
( ). Procedure Visual Basic.
|
|
, Click cmdOK:
Private Sub cmdOK_Clik()
MsgBox Visual Basic
End Sub
, , Object Browser , .
Object Browser , , .
V , , , .
, . , , . , Call . ,
Call sortList (name1)
Sub Insert Procedure Add Procedure Visual Basic. Sub , . Sub . 3.2.
. 3.2.
Function . , :
Function Square (I As Integer) As Integer
Square = I * I
End Function
, , :
J = Square (5)
, . , , . :
Square 5
, , . Visual Basic. , . VB , , .
Private Public. Private , , . Public , . , .
, , Private, , , .
Public - . , .
Publi, , .
Publi:
Public Sub Proc1 ()
.
.
.
End Sub
, :
Form1.Proc1
, :
Proc1
, , Function. , Public Private . .
() .