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

零教程

全部教程

VBA教程

例子