Excel VBA Function Archives

How to Use Concatenate in Excel VBA (4 Methods)

Jun 15, 2024

Download the Practice Workbook Download this practice workbook to exercise while you are reading this article. VBA Concatenate ...

How to Use Concatenate in Excel VBA (4 Methods)

How to Use VBA Val Function in Excel (7 Examples)

Aug 6, 2024

The VBA Val function is an Excel Text function which converts a text string into a numeric value. You can use this function in a VBA code to get the ...

How to Use VBA Val Function in Excel (7 Examples)

How to Use VBA MkDir Function in Excel (4 Examples)

Jul 6, 2024

We’ll first discuss how to write code in the Visual Basic Editor. Follow the simple steps to create the setup for writing your code. Steps: ...

How to Use VBA MkDir Function in Excel (4 Examples)

How to Use VBA Replace Function in Excel: 11 Methods

Jul 7, 2024

Method 1 - Use VBA Replace to Find a Word and Replace We have the following dataset of six students and their status of present or absent in the ...

How to Use VBA Replace Function in Excel: 11 Methods

How to Use the VBA Weekday Function (2 Suitable Examples)

Aug 4, 2024

In this article, we'll explain how to use the VBA Weekday function in Excel. VBA Weekday Function (Quick View) Running this code will ...

How to Use the VBA Weekday Function (2 Suitable Examples)

How to Use the VBA Mod Operator – 9 Examples

Aug 14, 2024

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

How to Use the VBA Mod Operator – 9 Examples

VBA Format Function in Excel: 8 Uses with Methods

Jul 6, 2024

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. ...

VBA Format Function in Excel: 8 Uses with Methods

VBA Date Function (13 Uses of Macros with Examples)

Jul 7, 2024

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

VBA Date Function (13 Uses of Macros with Examples)

How to Use VBA InStrRev Function (7 Suitable Examples)

Aug 6, 2024

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 VBA InStrRev Function (7 Suitable Examples)

How to Use VBA UCASE Function in Excel (4 Examples)

Aug 6, 2024

Excel provides several VBA functions that can be used while writing a macro or to define your own function to perform your desired tasks. In this ...

How to Use VBA UCASE Function in Excel (4 Examples)

The Excel VBA MsgBox Function – MsgBox Types, Constants and Return Values

Aug 14, 2024

Download Practice Workbook Download the following workbook. Excel VBA MsgBox Function.xlsm The MsgBox Function in Excel ...

How to Use VBA SPLIT Function in Excel (10 Ideal Examples)

Aug 5, 2024

How to Launch the VBA Editor in Excel If you don’t see the Developer tab, enable the Developer tab. Select the Developer tab and click on ...

How to Use VBA SPLIT Function in Excel (10 Ideal Examples)

How to Use the VBA Trim Function in Excel – 5 Examples

Aug 11, 2024

This is an overview. The VBA TRIM Function Summary The Trim function in VBA removes the leading and trailing spaces from a ...

How to Use the VBA Trim Function in Excel – 5 Examples

How to Use VBA Asc Function (5 Practical Examples)

Aug 2, 2024

Download Practice Workbook VBA Asc Function in Excel.xlsm Introduction to VBA Asc Function The VBA Asc function is a built-in function ...