位置:首页 » 文章/教程分享 » 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