Javatpoint Logo
Javatpoint Logo

VBA String Operator

The string data is used to hold a sequence of characters that can consist of numbers, alphabets, special characters (symbols) or all of them.

String operators are used to manipulating string data.

A variable is said to be a string if it is enclosed within double quotes ("").



You can concatenate the value of Mar-1997 from the first three letters of the month and the year like "Mar-1997".

Here are some string operators such as:

1. Concatenate (&): This operator is used to concatenate the two strings or values together.

For example, "Mary" & "Kom".

Output: MaryKom

Note: Concatenation operator can be used for the numbers as well as strings. The output depends on the context if the variables hold string value or a numeric value.


Step 1: First add a Button to the excel sheet as we have shown earlier.

  1. Change the name property such as btnconcatenate.
VBA String Operator

Step 2: Right-click on the button.

Step 3: Select View Code option.

Step 4: You will get the code window as shown in the below screenshot.

VBA String Operator

Step 5: Write the following code in between Private Sub btnAdd_Click and End Sub as follows:

VBA String Operator

Step 6: Click on the Save button.

Step 7: And close the code editor window.

Step 8: Then turn off the Design Mode button.

VBA String Operator

Step 9: The indicator is, it will change into a white background from the greenish colored background, as shown in the below screenshot.

VBA String Operator

Step 10: Click on the Concatenate button.

Step 11: Execute the above code, and you will get the output as shown in the below screenshot.

VBA String Operator

Help Others, Please Share

facebook twitter pinterest

Learn Latest Tutorials


Trending Technologies

B.Tech / MCA