VBA算術運算符

下表列出了所有VBScript語言支持的算術運算符。假設變量A=5和變量B=10，則：

運算符

描述

例子

+

相加兩個操作數

A + B = 15

-

第一操作數減去第二操作數

A - B = -5

*

兩個操作數相乘

A * B = 50

/

通過分子除以分母

B / A = 2

%

模運算和整數相除後的餘

B MOD A = 0

^

求冪運算符

B ^ A = 100000

例子

添加一個按鈕，並嘗試下面的例子來了解所有可用的算術運算符在VBA中：

Private Sub Constant_demo_Click() Dim a As Integer a = 5 Dim b As Integer b = 10 Dim c As Double c = a + b MsgBox ("Addition Result is " & c) c = a - b MsgBox ("Subtraction Result is " & c) c = a * b MsgBox ("Multiplication Result is " & c) c = b / a MsgBox ("Division Result is " & c) c = b Mod a MsgBox ("Modulus Result is " & c) c = b ^ a MsgBox ("Exponentiation Result is " & c) End Sub

當單擊按鈕或執行該腳本，這會產生以下結果：

Addition Result is 15

Subtraction Result is -5

Multiplication Result is 50

Division Result is 2

Modulus Result is 0

Exponentiation Result is 100000