, Variant.
. VBA , (. 4.1). VBA .
4.1
VBA
sinx | cosx | ex | |x| | tgx | arctgx | lnx | Öx | |
VBA | Sin(x) | Cos(x) | Exp(x) | Abs(x) | Tan(x) | Atn(x) | Log(x) | Sqr(x) |
Log n, n:
. , , , , .
: + (), (), * (), / (), ^ ( ), \ ( ), Mod ( ), .
, :
VBA :
Sin(3*x)+(Log(x-1)+Tan(x))/(x^3+Exp(x+3))^(1/4)
, ; ; ; ; ; . .
() : &, +.
, (, ) : .
Private Sub CommandButton4_Click()
nUserName = InputBox(" ?")
MsgBox " " & " " & nUserName
End Sub
. : < > = < >
:
= 5*a + log(a + 0.5)-a^3
= − , .
. . Excel.
InputBox, . , : a = InputBox(" ") , , , (. 4.2). .
. 4.2 − InputBox
InputBox String. Val. , 7.35 b :
|
|
b = Val(InputBox(" b"))
. , , 6,2×10-8 6.2-8
Excel . A4 2 , , :
x=Worksheets("2").Range("A4")
x=Worksheets("2").Cells(4, 1)
Worksheets("2") Excel 2, Range("A4") 4, Cells(4, 1) 4 1.
. , , Excel.
MsgBox. , MsgBox y y.
, . , MsgBox(" ") c : .
, ( ). Format(x, "##.##"), x , ##.## ( ).
&, :
MsgBox (" x=" & Format(x, "##.#"))
Excel A4:
Worksheets("1").Range("A4") = x
Worksheets("1").Cells(4, 1) = x
, .
. x=1,5 a=3,75 m=0.5 10-4 w z :
2 4.3:
. 4.3 − Excel
: