|
admin0301 发表于 2012-10-5 17:03
比如我在窗体输入1,55,得到结果27.28
输入2,56,得到结果27,29
输入6,58,得到结果26,32 - Private Sub 递归计算_Click()
- Dim i1 As Long
- Dim i2 As Long
- Dim iC As Long, iH As Long
- Dim iok As Boolean
- If VBA.IsNumeric(TextBox1.Text) And VBA.IsNumeric(TextBox2.Text) Then
- iC = TextBox1.Text
- iH = TextBox2.Text
- i1 = (iH - iC) \ 2
- i2 = i1 + iC
-
- If i1 + i2 = iH Then iok = True
- End If
- If iok Then
- [a5] = i1
- [b5] = i2
-
- Else
- [a5] = ""
- [b5] = ""
- MsgBox "非法数据,请重新输入"
- End If
- End Sub
复制代码 我之前的代码里限定了3,现在可以了。
|
|