为什么当我在VBA Excel中输入一个操作时，VBA会删除操作符？

Question

我会写这样的东西：

Dim Counter As Integer
Dim a As Integer
Counter = 0
a = 1
Counter-a 

但是，VBA将其附加到以下内容：

Dim Counter As Integer
Dim a As Integer
Counter = 0
a = 1
Counter a '<---------------This change is what I am confused about

到目前为止，这是我的完整代码：

Private Sub SpinButtonM_SpinDown()
Dim Counter As Integer
Dim a As Integer
a = 1
Counter a
UserForm2.Month.Caption = Counter
End Sub

Answer 1

你必须像这样减少：

Counter = Counter - a

Answer 2

如果要从变量a中减去变量Counter，则需要将该减法的结果存储在某个地方。因此，您可能需要引入另一个变量，如

Dim result as Integer
...
result = Counter - a
msgbox(result)

或者您希望通过Counter减少a变量，那么您需要

Counter = Counter - a