Excel VBA Function

How to Use Concatenate in Excel VBA (4 Methods)

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

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

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 MkDir Function in Excel (4 Examples)

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 Replace Function in Excel: 11 Methods

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 the VBA Weekday Function (2 Suitable Examples)

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

How to Use VBA Mod Operator (9 Examples)

The VBA Mod is not a function whereas MOD is a function in an Excel worksheet. VBA Mod is an operator which divides two numbers and returns the ...

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

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 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 VBA UCASE Function in Excel (4 Examples)

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

Excel VBA MsgBox Function (All MsgBox Types, Constants & Return Values)

MsgBox is a remarkably effective method or tool to make Excel operations more accessible and user-friendly. MsgBox can show distinct types of outputs ...

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

Are you working with some strings and need to split them into multiple parts? Then, you are in the right place. When working in Excel, we may need to ...

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

This is an overview. Introduction to the VBA TRIM Function Summary The Trim function in VBA removes the leading and trailing ...

How to Use VBA Asc Function (5 Practical Examples)

In this article, we will discuss Excel VBA Asc Function. It is a convenient tool. I hope you will find the article interesting and can increase your ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo