|
用VBA为什么inputbox会出错如何改
运行下面这个VBA,为什么单击"取消" 会提示"类型不匹配"
如何改单击"取消" 不会出现错误提示
sub 加法计算器()
dim jiashu as integer
dim beijiashu as integer
dim he as integer
jiashu=inputbox("请输入加数","加法计算器")
beijiashu=inputbox("主伐输入被加数","加法计算器")
he=jiashu+beijiashu
msgbox "两数求和的结果为:" & he,vbokonly,"加法计算器"
end sub
- sub 加法计算器()
- dim jiashu$,beijiashu$
- dim he as integer
- jiashu=inputbox("请输入加数","加法计算器")
- beijiashu=inputbox("主伐输入被加数","加法计算器")
- if isnumeric(jiashu) and isnumeric(beijiashu) then
- he=jiashu*1+beijiashu*1
- msgbox "两数求和的结果为:" & he,vbokonly,"加法计算器"
- else
- msgbox "Error!"
- exit sub
- end if
- end sub
复制代码
|
|