Visual basic for Application (VBA)
VBA. , , .
: , . .
: , , .
: ,
: Variant (, )
Integer ( ); String ( ); Boolean ( ); Date ( ); Singee/Double ( )
.
VBA.
VBA :
Sub () - :
Sub Farewell()
MsgBox Goodbye
End Sub
VBA Sub, . VBA Office. , , .
Function () , . : - , . :
Function Tomorrow()
Tomorrow = DateAdd("d", 1, Date())
End Function
, - . Tomorrow =DateAdd(" d", 1, Date()).
VBA (event procedure) Sub , .
Property ( ). , , .
VBA.
Application
Application () Excel Excel. 120 40 .
Workbook Workbooks
Excel workbook ( ) Application . XLS ( ) XLA ( ). .
Worksheet Worksheets
Excel worksheet workbook .
Range Selection
Excel Range () worksheet. Range VBA. Selection () VBA Select, selection. . Selection Range Range. Range selection , .
|
|
.
- .
- , .
:
If () then
1
2
n
Else
1
n
End if
.
5. .
- , - .
For = to Step ()
1
2
Next
For... Nex t , , .
-:
.
Do While/Until ()
1
2
Loop
.
Do
1
2
Loop While/Until ()
- 6, .
8. / .
InputBox.
MsgBox.
MsgBox .
:
MsgBox [,][, ]
:
- , . , &. Chr(13) .
- . , - . , , , . . 3.1 .
- .
MsgBox Integer, , .
InputBox :
_ = InputBox( [, ] )
:
- . ,
- .
, N , 10.
:
N = InputBox(" N", " ",10)
N.