, . Exit Do , .
Counter = 99 Do Until Counter <= 0 If Counter > 50 Then MsgBox " " | Exit Do End If Call MySubroutine Counter = Counter 2 Loop |
, Counter 50. .
WhileWend
WhileWend DoLoop. Basic, DoLoop, WhileWend. :
While []
Wend
DoLoop , WhileWend:
Counter = 100
While Counter > 0
Call MySub
Counter = Counter - 1
Wend
WhileWend DoLoop , . , , Exit Do.
ForNext
ForNext . . :
For = To [Step ]
[]
Next
- , . , - . :
Sub _()
For i = 1 To 8
Select Case i
Case 1
= ""
Case 2
= ""
Case 3
= ""
Case 4
= ""
Case 5
= ""
Case 6
= ""
Case 7
= ""
Case Else
= " "
End Select
MsgBox ()
Next i
End Sub
, i . . 1, , Step . , , .
, .
, . .
, :
Rnd() [0; 1);
|
|
Int() ;
Chr(13) ( Enter).
1. VBA , .
2. .
3. :
Public Sub _() Dim numbers(6) As Double Dim a As Double N = InputBox(" ") For i = 1 To N a = Int(Rnd() * 6) + 1 numbers(a) = numbers(a) + 1 Next i | info = " " & Chr(13) & Chr(13) & _ "1 - " & numbers(1) & _ " 4 - " & numbers(4) & Chr(13) & _ "2 - " & numbers(2) & _ " 5 - " & numbers(5) & Chr(13) & _ "3 - " & numbers(3) & _ " 6 - " & numbers(6) MsgBox (info) End Sub |
1. .
2. ?
3. For, Step, Next?
4. ?
5. ?