Macros & Excel VBA

How to Use the VBA Mod Operator – 9 Examples

This is an overview.   Download to Practice Examples of VBA Mod Operator.xlsm The VBA Mod Function Summary The VBA ...

VBA EXP Function in Excel (5 Examples)

VBA Exp function is a built-in function in Excel, categorized under the Math and Trig function. In this article, we will show you what Exp function ...

VBA Format Function in Excel: 8 Uses with Methods

Method 1 - VBA to Format Numbers with Predefined Formats Below is the VBA code which covers all the predefined formats to Format numbers in Excel. ...

How to Use VBA IsNumeric Function (9 Examples)

If you are looking for some of the easiest ways to use the VBA IsNumeric function, then you are in the right place. We generally use this function in ...

How to Use VBA Right Function in Excel (6 Examples)

The VBA Right function in Excel returns a substring from within a string based on a specified location from the right to the left of that string. We ...

How to replace the Text of a Cell Based on a Condition in Excel – 5 Methods

Method 1 - Replacing Text using the Find and Replace Tool in Excel This is the sample dataset. Step 1: Go to the Home tab. Click ...

VBA If – Then – Else Statement in Excel (4 Examples)

Conditional statements are used to perform a set of actions depending on the specified condition in programming languages. In this article, we will ...

How to Use VBA TimeValue Function (6 Relevant Examples)

Often, we may have a time string in a format where the time value is not separate. In such a situation, using the VBA TimeValue function will be a ...

How to Use IsDate Function in VBA (3 Examples)

The IsDate function is a built-in VBA Information function in Excel that you can use in a lot of scenarios. Besides, you can perform various ...

How to Use VBA Case Statement (13 Examples)

The CASE statement is a logical function, which can be used instead of the IF-THEN-ELSE statement. VBA Case Statement: Syntax & Arguments ...

VBA Date Function (13 Uses of Macros with Examples)

Download Practice Workbook Uses of VBA Date.xlsm Function 1 - DateAdd Function as Date in VBA In VBA, we use the DateAdd function to ...

How to Use Reference from Another Excel Workbook Without Opening it – 5 Examples

Example 1 - Use a Reference from Another Workbook Using the Paste Link Option Step 1: Open the worksheet: Closed.xlsm. Copy B5:C9. ...

How to Use VBA InStrRev Function (7 Suitable Examples)

When you need to find the position of a character inside a string or the occurrence of a substring inside a string, the VBA InStrRev function might ...

How to Use the VBA Chr Function (2 Examples)

One of the most important and widely used functions of VBA is the Chr function. In this article, I’ll show you how you can use the VBA Chr function ...

How to Use VBA in an Excel Table – 9 Methods

This dataset showcases a table with headers. Method 1 - Creating a Table with VBA in Excel Declare the Table as a ListObject. ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo