Run, .
Run Þ RunSub,
< F5 > . , , .
, ,
Run Þ Break,
< Ctrl >+< Break > . , , , , , , .
, . ,
End , Debug, . RunSub , . , RunSub
Run Þ Reset
.
, , . ( Dim) , ( ) ReDim.
,
Dim () As Single, () As Single
.
n = 5
m = 20
.
ReDim (16), (n, m)
.
Dim , ReDim , , , 16, n m.
-. ( ) , , , . VBA . InputBox ( ) MsgBox ( ).
InputBox , : OK ( ) Cancel (). OK. , . :
InputBox (< > [, < >] [, < default >])
|
|
< > ;
< > ( MS Excel);
< default > , ( ).
,
= InputBox(" ", " ", 30000)
, . OK .
< > < > , ( &). , . ,
number = 5
Q = InputBox(" " & number & "- ", " ", 0)
(< >) . Chr 13. ,
= InputBox(" " & Chr(13) & " ", " ", 0)
, & +. ,
= InputBox(" " + Chr(13) + " ", " ", 0)
, . , CStr. , number integer (),
Q = InputBox(" " + number + "- ", " ", 0)
. , number (string):
Q = InputBox(" " + CStr(number) + "- ", " ", 0)
MsgBox (Ok, , , ..). MsgBox .
:
MsgBox (< > [, < >] [, < >])
< > < > , InputBox, . < > :
vbOkOnly Ok ;
vbOkCancel Ok ;
vbYesNo ;
vbYesNoCancel , ;
vbAbortRetryIgnore , ;
vbRetryCancel .
vbOkOnly.
|
|
:
vbYes ; vbNo ; vbCancel ..
, , , . < > ( +) :
vbInformation , ;
vbQuestion ;
vbExclamation ;
vbCritical .
,
v = 10
f = MsgBox( + CStr (v) + ?; vbYesNo+vbQuestion; )
, v, ( ) Question ( ).