第1个回答 2011-04-08
dim num as long
'赋值num…… 省略
'判断输入是数字
dim 整数 as string
dim 小数 as string
if isnumeric(num) then
'把数字看成字符,以点为分割成一个数组
整数 = split(Cstr(num),".")(0)
小数 = split(Cstr(num),".")(1)
end if
方法二:数学运算方式
整数 = int(num)
小数 = num - int(num)
第2个回答 2011-04-08
Private Sub Command1_Click()
On Error Resume Next
Dim mstr$
mstr = InputBox("input")
If Len(mstr) - Len(Replace(mstr, ".", "")) <> 1 Then MsgBox " 输入不合规范": Exit Sub
Print Split(mstr, ".")(0)
Print Split(mstr, ".")(1)
End Sub