VBA Goto, , . . .
1.12. . , .
Sub primer1_12()
nachalo: x = InputBox(" ")
If x < 0 Then Goto konec
koren = Sqr(x)
MsgBox (" " & koren)
Goto nachalo
konec: End Sub
nachalo konec .
.
() . . , () . , (, ). , .
1.13. , . .
Sub primer1_13()
Dim a() As Single
m = InputBox(" ")
n = InputBox(" ")
ReDim a (1 To m, 1 To n), asum(1 To n)
For i = 1 To m
For j = 1 To n
a(i, j) = InputBox("a(" & i & "," & j & ")")
Next j
Next i
nomer_stroki = InputBox(, )
Call poisk_max(a, n, nomer_stroki, max_elem, nomer_max_elem)
MsgBox( & i & - & max_elem)
MsgBox( & nomer_max_elem & - )
End Sub
Sub poisk_max(massiv, kol_stolb, i, max, nom_max)
max=massiv(i,1): nom_max=1
For j=1 To kol_stolb
If massiv(i,j)>max Then
max = massiv(i,j)
nom_max = j
Next j
End Sub
primer1_13 ( ) , poisk_max . , ( ) . .
( a). nomer_stroki , . , , .
Call . :
Call poisk_max(a, n, nomer_stroki, max_elem, nomer_max_elem)
poisk_max . a, n nomer_stroki , . max_elem nomer_max_elem , .
|
|
:
Sub poisk_max(massiv, kol_stolb, i, max, nom_max)
, (.. Call) , .
poisk_max massiv a (.. , ), kol_stolb n, i nomer_stroki. max nom_max max_elem nomer_max_elem; , .
poisk_max. max nom_max. , max_elem nomer_max_elem.
. , Call. MsgBox, .
, . , , , ; , . :
Call poisk_max(a, n, 3, max_elem, nomer_max_elem)
poisk_max . i 3. , .
.
, , . , , .
, , .
, , , .. , . , .
, . Call. .
1.13. . .
Sub primer1_13()
Dim a() As Single, b() As Single
n = InputBox(" ")
ReDim a(1 To n), b(1 To n)
MsgBox (" ")
For i = 1 To n
a(i) = InputBox(" " & i & ": ")
Next i
MsgBox (" ")
For i = 1 To n
b(i) = InputBox(" " & i & ": ")
|
|
Next i
d = rasst(a, b, n)
MsgBox (" " & d)
End Sub
Function rasst(x, y, razmernost)
rasst = 0
For i = 1 To razmernost
rasst = rasst + (x(i) - y(i)) ^ 2
Next i
rasst = Sqr(rasst)
End Function
rasst . d = rasst(a, b, n). , a b ( ), n ( , .. ) rasst. rasst x, y razmernost . . rasst. , ( rasst). rasst : , , .. d = rasst(a, b, n). , rasst d. MsgBox.