VBA String Operator. String operators are used to manipulate string data. A string can include alphabets, numbers, and special characters in a sequence. A string’s special advantage is that it can contain all kinds of characters in a single string.
For example, you can concatenate the value of “Hello” and “World” in a single string.
Examples of Strings in Excel
Alphabets
Str1 = “AnyText”
Numbers
Str2 = “17”
Special Characters
Str3 = “!@#$”
String Operator in VBA
Concatenate (&): Two Strings or Values are Combined Together Using a Concatenate Operator. This is one of
str1 = “Hello”
str2 = “World”
For Example, strValue = str1 & ” ” & str2
Output: Hello World
See More: Excel VBA Tutorial
Example
Step 1: Add a Button to the Excel Sheet as we Have shown in the Previous Article.
1. Change the Name Property Such as Btnconcatenate.
Step 2: on the Button and Select the View Code Option. You will get the code Window as Shown in the Below Screenshot.
Step 3: Write the Following Code in Between Private Sub cmdButtonConcatenate_Click and End Sub as follows.
MsgBox “Hello” & “World”, vbOKOnly, “Concatenate Operator”
Step 4: Click on the Save Button and Close the Code Editor Window.
Step 5: Turn off the Design Mode Button.
Step 6: The Indicator will Change into a white Background From the Greenish-Colored Background as Shown in the Screenshot.
Step 7: Click on the cmdButtonConcatenate button.
Step 8: Execute the Above Code and get the Type of Output Shown in the Below Screenshot.