VB做高级计算器
时间:2008-04-27
来源:互联网
作者: lml285290661 发布时间: 2008-04-27
'-----------------------------------
Function result(ByVal x As String)
Dim myobj As Object
Set myobj = CreateObject("excel.sheet")
Set myobj = myobj.Application.ActiveWorkbook.ActiveSheet
myobj.Range("a1").Formula = "= " & x
result = myobj.Range("a1").Value
If Err.Number > 0 Then MsgBox Err.Description
Set myobj = Nothing
End Function
Private Sub Command1_Click()
Dim x As String
x = Text1.Text
Text2 = result(x)
End Sub
Private Sub Form_Load()
Text1.Text = "312*9345"
End Sub
'在excel20003+vb+winxp下成功
作者: lianxiangpanjin 发布时间: 2008-04-27
作者: zzyong00 发布时间: 2008-04-27
Private Sub Text1_KeyPress(KeyAscii As Integer)
If KeyAscii = 13 Then Call calc(Text1)
End Sub
Sub calc(tmpstr As String)
Set sc = CreateObject("ScriptControl")
sc.Language = "VBScript"
Text1.Text = sc.Eval(tmpstr)
Set sc = Nothing
End Sub

作者: cbm666 发布时间: 2008-04-27
作者: Chen8013 发布时间: 2008-04-27
作者: cqcpl 发布时间: 2008-04-30
作者: RUKYO 发布时间: 2008-04-30
作者: meiZiNick 发布时间: 2008-05-01
作者: lml285290661 发布时间: 2008-05-03
作者: Chen8013 发布时间: 2008-05-03
VbScript 你不喜欢, 下面这个你再不能接受的话, 我想你只有去找 彼尔 啦.........
Option Explicit
Private Declare Function EbExecuteLine Lib "vba6.dll" (ByVal pStringToExec As Long, ByVal Unknownn1 As Long, ByVal Unknownn2 As Long, ByVal fCheckOnly As Long) As Long
Private Sub Command1_Click()
ExecuteLine "RtnVal = " & Text1.Text
ExecuteLine "clipboard.settext RtnVal"
Text1.Text = Clipboard.GetText
End Sub
Public Function ExecuteLine(sCode As String, Optional fCheckOnly As Boolean) As Boolean
ExecuteLine = EbExecuteLine(StrPtr(sCode), 0&, 0&, fCheckOnly) = 0
End Function
作者: cbm666 发布时间: 2008-05-03
推荐一个示例程序,可以直接用,还有源代码,LZ一定试下。
http://download.csdn.net/detail/txzsp/3781512
作者: txzsp 发布时间: 2011-11-11
热门阅读
-
office 2019专业增强版最新2021版激活秘钥/序列号/激活码推荐 附激活工具
阅读:74
-
如何安装mysql8.0
阅读:31
-
Word快速设置标题样式步骤详解
阅读:28
-
20+道必知必会的Vue面试题(附答案解析)
阅读:37
-
HTML如何制作表单
阅读:22
-
百词斩可以改天数吗?当然可以,4个步骤轻松修改天数!
阅读:31
-
ET文件格式和XLS格式文件之间如何转化?
阅读:24
-
react和vue的区别及优缺点是什么
阅读:121
-
支付宝人脸识别如何关闭?
阅读:21
-
腾讯微云怎么修改照片或视频备份路径?
阅读:28