可以在Sheet的Change事件中增加处理方法:Option Explicit' 这里有一个问题,就是输入减法的时候Excel会自动当作日期处理. Private Sub Worksheet_Change(ByVal Target As Range) Dim reg As Object Set reg = CreateObject("vbscript.regexp") reg.Pattern = "\d+[+\-*/]\d+"
If reg.test(Target.Text) Then Cells(Target.Row, Target.Column + 1) = Evaluate(Target.Text) End If End Sub运行示例:下载地址: 链接:https://pan.baidu.com/s/1mzx1hklZHInDCQywXsmYbA 提取码:v3k2
Private Sub Worksheet_Change(ByVal Target As Range)
Dim reg As Object
Set reg = CreateObject("vbscript.regexp")
reg.Pattern = "\d+[+\-*/]\d+"
If reg.test(Target.Text) Then
Cells(Target.Row, Target.Column + 1) = Evaluate(Target.Text)
End If
End Sub运行示例:下载地址:
链接:https://pan.baidu.com/s/1mzx1hklZHInDCQywXsmYbA
提取码:v3k2