Macros & Excel VBA

How to Use For Each Loop in Excel VBA (3 Suitable Examples)

Example 1 - Using Excel VBA For Each Loop Statement with Range Object Let’s say we have a workbook with one worksheet, the cells E4: E11 containing ...

How to Use the Do While Loop in Excel VBA – 3 Examples

Download Practice Workbook Download the practice workbook. Do While Loop.xlsm The Do While Loop in Excel VBA The syntax is: Do While ...

How to Use Do Until Loop in Excel VBA (with 2 Examples)

In this article, we will explain how to use the Do Until Loop in Excel VBA with two simple examples. What Is a Loop? A Loop is a programming ...

Changing Case using Worksheet Functions and Excel VBA

Excel provides the text worksheet functions, namely the Upper Function, the Lower Function, and the Proper Function, which can change the case of a ...

How to Use For Next Loop in Excel VBA (10 Suitable Examples)

A loop is used when we need to run an operation repeatedly. Without performing the same operation manually every time in Excel, we can apply the VBA ...

IF & AND Functions in Excel VBA to Test Multiple Conditions

We have already seen how to use the IF & AND worksheet Functions to test multiple conditions, in a previous tutorial. We are now going to see how ...

How to Use Select Case Statement in Excel VBA (2 Examples)

Download Practice Workbook Select Case Statement.xlsm Using the sample dataset below, we will illustrate two examples to use the Select ...

How to Reference Excel Tables Using VBA (20 Examples)

Reference a Table with ListObject Property When writing VBA code, ListObjects are essential for referring to Excel tables. These tables can be ...

How to Use the INDEX MATCH with Excel VBA – 9 Steps

  Download Practice Workbook Download the practice workbook and practice. INDEX-MATCH.xlsx Step1 - Apply the INDEX and the MATCH ...

How to Use Form Controls in Excel (Detailed Analysis)

  Download the Practice Workbook Form Controls.xlsm What Are Form Controls in Excel? Form controls in Excel are objects we can ...

Best 7 Books on Financial Modelling Using Excel

Where do financial modelers work? The world of finance can be a very complex place that at times, it is quite tricky to navigate. For instance, ...

6 Best Excel VBA Programming Books (For Beginners & Advanced Users)

Do you often find yourself doing repetitive tasks over and over again in Excel and wishing that somehow, someway, these tasks could be automated? ...

How to Create a Body Mass Index Calculator in Excel Using VBA (Step-by-Step)

  Step 1 - Creating a UserForm Go to Developer > Code > Visual Basic options. Click on the UserForm option from the ...

How to Use Substring Functions in Excel (Types and Examples)

Function Type 1 - UPPER, LOWER, and PROPER Functions: Syntax and Arguments With the UPPER, LOWER or PROPER functions, you can change the case of ...

How to Import Data from Website to Excel with VBA Code: 2 Ideal Methods

Method 1 - Import Specific Data from Website to Excel VBA MsgBox STEPS: Go to the Developer tab from the ribbon. Click on Visual Basic from ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo