VBA支持以下連接運算符。
假設變數A=5，變數B=10，則 -
| 運算符 | 描述 | 示例 |
|---|---|---|
+ |
將兩個值添加為變數，其值是數字 | A + B = 15 |
& |
連接兩個值 | A & B = 510 |
示例1
試試下麵的例子來理解VBScript中可用的連接運算符 -
Private Sub Constant_demo_Click()
Dim a as Integer : a = 5
Dim b as Integer : b = 10
Dim c as Integer
c = a + b
msgbox ("Concatenated value:1 is " &c) 'Numeric addition
c = a & b
msgbox ("Concatenated value:2 is " &c) 'Concatenate two numbers
End Sub
執行上面示例代碼，得到類似下麵的結果 -
Concatenated value:1 is 15
Concatenated value:2 is 510
假設變數A = "Microsoft"，變數B = "VBScript"，則 -
| 運算符 | 描述 | 示例 |
|---|---|---|
+ |
連接兩個值 | A + B 的結果為MicrosoftVBScrip |
& |
連接兩個值 | A & B 的結果為MicrosoftVBScrip |
注 - 連接操作，可用於數字和字串。輸出取決於上下文，如果變數保存數字值或字串值。
示例2
嘗試下麵的示例，通過創建一個按鈕並添加以下函數來瞭解VBA中可用的所有邏輯運算符。
Private Sub Constant_demo_Click()
Dim a as String : a = "Microsoft"
Dim b as String : b = "VBScript"
Dim c as String
c = a + b
msgbox("Concatenated value:1 is " &c) 'addition of two Strings
c = a & b
msgbox("Concatenated value:2 is " &c) 'Concatenate two String
End Sub
執行上面示例代碼，得到類似下麵的結果 -
Concatenated value:1 is MicrosoftVBScript
Concatenated value:2 is MicrosoftVBScript