VBA for Beginners – Chapter 07 : Concatenating strings

Free eBooks for Beginners

VBA, or Visual Basic for Applications, is a programming language that can be used to automate tasks in Microsoft Office programs like Excel, Word, and PowerPoint. In this article, we will focus on how to concatenate strings in VBA as a beginner.

Concatenation is the process of combining two or more strings together to create a new string. In VBA, you can use the “+” operator to concatenate strings. For example, if you have two string variables, “myString1” and “myString2”, you can concatenate them together like this:

myString3 = myString1 + myString2

The resulting string, “myString3” will contain the text from both “myString1” and “myString2”, with no space between them. If you want to add a space between the strings, you can concatenate a space string to the end of the first string, like this:

myString3 = myString1 + " " + myString2

You can also use the built-in function called “&” operator to concatenate strings. It is an alternative way of concatenating strings, instead of using “+” operator. For example, you could concatenate the same two strings using the “&” operator like this:

myString3 = myString1 & myString2

It’s also possible to concatenate strings that are stored in cells of a worksheet in Excel. For example, if you have a worksheet with the following data:

A1: "Hello" A2: "World"

You can concatenate the two cells together by referencing the cells in the concatenation:

myString3 = Worksheets("Sheet1").Range("A1").Value + " " + Worksheets("Sheet1").Range("A2").Value

It’s important to note that when concatenating strings, you must make sure that the variables you are using are indeed strings. If you try to concatenate a string with a number, for example, you will get a type mismatch error.

In addition, when working with strings, it’s also important to keep in mind that strings are case-sensitive. This means that “hello” is not the same as “Hello” in VBA.

In conclusion, concatenating strings is an important part of VBA programming. It allows you to combine two or more strings together to create a new string. Understanding how to concatenate strings in VBA will help you to create more advanced and powerful macros, whether it’s by using the “+” operator, the “&” operator, or by referencing cells in a worksheet.


VBA for Beginners – Chapter 07 : Concatenating strings


Loader Loading...
EAD Logo Taking too long?

Reload Reload document
| Open Open in new tab

Download PDF [70.68 KB]

Applied Machine Learning & Data Science Projects and Coding Recipes for Beginners

A list of FREE programming examples together with eTutorials & eBooks @ SETScholars

95% Discount on “Projects & Recipes, tutorials, ebooks”

Projects and Coding Recipes, eTutorials and eBooks: The best All-in-One resources for Data Analyst, Data Scientist, Machine Learning Engineer and Software Developer

Topics included: Classification, Clustering, Regression, Forecasting, Algorithms, Data Structures, Data Analytics & Data Science, Deep Learning, Machine Learning, Programming Languages and Software Tools & Packages.
(Discount is valid for limited time only)

Disclaimer: The information and code presented within this recipe/tutorial is only for educational and coaching purposes for beginners and developers. Anyone can practice and apply the recipe/tutorial presented here, but the reader is taking full responsibility for his/her actions. The author (content curator) of this recipe (code / program) has made every effort to ensure the accuracy of the information was correct at time of publication. The author (content curator) does not assume and hereby disclaims any liability to any party for any loss, damage, or disruption caused by errors or omissions, whether such errors or omissions result from accident, negligence, or any other cause. The information presented here could also be found in public knowledge domains.


Learn by Coding: v-Tutorials on Applied Machine Learning and Data Science for Beginners