Excel VBA Function

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 FileDateTime Function in Excel (3 Uses)

In Microsoft Excel, we use the VBA FileDateTime function to find out the last modification date of any drive, file, or directory. In this article, we ...

How to Use VBA ROUND Function in Excel (6 Quick Uses)

In this article, we will illustrate the use of the VBA Round function. Rounding is basically a mathematical term. It makes a decimal value shorter ...

How to Use VBA TimeSerial Function in Excel (3 Examples)

The TIMESERIAL in Excel is a built-in Date/Time function that can be used in VBA. The TIMESERIAL function returns a time or Variant (Date) given an ...

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 WeekdayName Function in Excel (2 Examples)

The WeekdayName function in Microsoft Excel returns a string that represents the day of the week when given a number between 1 and 7. The WeekdayName ...

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

The Fix function is categorized under the Math function list in Excel VBA. It is an inbuilt VBA Function. This function is used to remove the ...

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 VBA Rnd Function in Excel (4 Methods)

The Rnd function in Excel VBA returns a Single containing a pseudo-random number. Rnd is the abbreviation of Random. The Rnd function returns a value ...

How to Use the VBA Environ Function (4 Examples)

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

How to Use VBA Int Function in Excel ( 3 Examples)

The Int function in Microsoft Excel returns the integer part of a value. The VBA Int is a built-in function in Excel. In Excel, it can be used as a ...

How to Use VBA IsEmpty Function (5 Relevant Examples)

When you need to check whether a cell remains empty/blank or not. In such circumstances, you may utilize the VBA IsEmpty function to identify the ...

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

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

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo