Tag Archives: Strings

No Thumbnail

Using VBA Like to Compare Strings

What is a Regular Expression? How is the Like Operator Related? In any programming language, there is a way to compare strings against some patterns. Several characters are used to create these patterns. These patterns are called regular expressions. Like in structured query language, VBA

How to Use VBA Input Boxes, With Examples

As a program runs, you might have a parameter which changes the flow conditionally. This parameter could be an input dependent on the user. Therefore, a VBA program needs to be a way to receive input from the user during runtime. This is where InputBox

How to Check if an Array Is Empty in VBA

When a list or collection of items that are the same data type are stored in continuous memory locations, we call it an array. Arrays are useful objects that are widely used in software development to organize data. Some real examples of where you might

The Guide to Removing Characters from Strings in VBA

String manipulation is a crucial skill in VBA programming. The skill level of a VBA developer is often determined by how well he/she can manipulate string data. Excel is very strong in mathematics operations and comes with loads of built-in calculation functions. But text manipulation

The Complete Guide to Regex in VBA

Regular Expressions (Regex) are a pattern that is used to find matches within strings. This is very useful when you want to validate, replace, or extract data from strings. In Excel, regular expressions can be used when working with VBA. Matching Characters The Pattern is

No Thumbnail

VBA Converting Data Types

In this article I will explain how you can convert data types to one another. Jump To : String Conversions Convert String to a Numeric Data Type Check if String is Numeric, IsNumeric() Convert String to Integer, CInt() Convert String to Double, CDbl() Convert String to