Working with Strings
Data structures composed of a sequence of alphanumeric characters, strings are basic in concept, but getting the information you require from them can be a different story.
In This Section
- Comparing Strings
Compare strings to determine whether they contain equivalent characters and how they differ if they do not match. - Calculating String Length
Determine the length of a string using the Len function to parse its contents. - Searching a String
Search strings to find out whether they contain a particular character or group of characters by using the InStr or InStrRev functions. - Returning Portions of a String
Learn how to parse the string to be able to work with part of a string's contents. - Working with Strings as Arrays
Quickly turn once-lengthy string-manipulation procedures into just a few lines of code. - Finding and Replacing Text Within a String
Find and replace all occurrences of a substring within a string using the Replace function. - Converting Text in a String from One Case to Another
Use the Microsoft® Visual Basic® for Applications (VBA) StrConv function to convert text in a string from one case to another. - Working with String Variables
Understand how to dimension a variable, assign a value to it, and output that variable as part of a string.
Related Sections
- Getting the Most Out of Visual Basic for Applications
Write code that is fast, efficient, easy to read and maintain, and, if possible, reusable with a solid working knowledge of Microsoft® Visual Basic® for Applications (VBA) — what features the language includes and what you can do with it. - Working with Numbers
Learn how to use numeric values and data types in Microsoft® Visual Basic® for Applications (VBA). - Working with Dates and Times
Manipulate date values in Microsoft® Visual Basic® for Applications (VBA), and understand how VBA stores date values internally. - Working with Files
Understand the Microsoft Scripting Runtime object library, and work with drives, folders, and files as objects. - Understanding Arrays
Use arrays when you must store a number of values of the same type, but you don't want to create individual variables to store them all. - Tips for Defining Procedures in VBA
Define a Function or Sub procedure, and use the options available to you to make your code more extensible or more flexible. - Optimizing VBA Code
Understand how to streamline your Microsoft® Visual Basic® for Applications (VBA) code to streamline your memory requirements.