自动计算文本框里的值
我有个文本框,输入1*2+4*5自动得到结果显示在Label1上结果为22
2015-04-17 15:44

2015-04-17 16:05
2015-04-21 09:23
2015-04-21 10:11
2015-04-21 10:40
2015-04-21 11:38
程序代码:Private Sub Command1_Click()
Dim EXAPP As Excel.Application
Dim WB As Excel.Workbook
Dim sht As Excel.Worksheet
Dim cz As String
Set EXAPP = CreateObject("excel.application")
Set WB = EXAPP.Workbooks.Open("c:\test.xlsx")
Set sht = WB.Worksheets("Sheet1")
sht.cells(5, 1) = Text1.Text
sht.cells(5, 2) = "=" & Text1.Text
WB.Save
Label1.Caption = sht.cells(5, 2)
WB.Close
Set sht = Nothing
Set WB = Nothing
Set EXAPP = Nothing
End Sub
2015-04-21 12:17