All posts by Lakshmi Ramakrishnan

Guide: Do Until Loops in VBA

Loops in VBA Just like any other programming language, VBA also provides several loops that help with the repeated execution of a specific piece of code for a certain number of iterations based on defined conditions. The list of loops provided by VBA are:  For

How to Find an Exact Match Using VBA

The Search Feature in Microsoft Excel Before digging into how to look for exact matches in VBA, I’ll give you some context with the easiest way to accomplish this goal — the search function in Excel. Microsoft Excel provides us with an excellent feature that

For Loops in VBA and the Continue Statement

Loops in VBA Loops are an essential part of any programming language because they help with the repeated running of any code snippet. Just like any other language, VBA offers the following loops to enable efficient programming: Do until Do while For Foreach In this

How Nested Ifs In VBA Work with Examples

All programming languages support the “if” type of conditional statement. An if block is executed during runtime only if the condition is met. i.e., the result of a condition is equal to the Boolean value “true.” Syntax If ( <conditional expression> ) ‘block of statements

Docmd.RunSQL in Access VBA

Microsoft Access is a Database Management System which helps to store and manage data, reporting using forms/queries/various other wizards. As discussed in older posts and articles, queries can be built in Microsoft Access using design view/SQL view/any available wizard. In another post I explain the