Macros & Excel VBA Archives

How to Format Text Using Excel VBA (12 Methods)

Jan 13, 2022 Excel Basics

In this article, we’ll illustrate how to change the format of a text in Excel using VBA code. While working with a large amount of information, ...

Cell Reference in Excel VBA (8 Ways)

Jan 13, 2022 Excel Basics

In this article, I’ll show you how you can access a cell reference in VBA in Excel. You’ll learn to access a single cell, as well as multiple cells ...

How to Use Year Function in Excel VBA (5 Suitable Examples)

Jan 13, 2022 Macros & Excel VBA

The Year function in Excel VBA is under the Date and Time category functions. If we use it in a VBA code, it extracts the year from the date which we ...

How to Use Excel VBA MONTH Function (7 Suitable Examples)

Jan 13, 2022 Macros & Excel VBA

The MONTH function falls under the Date or Time category. The MONTH function works both in worksheet and VBA Macros. It takes only one argument. In ...

How to Use the Advanced Filter in VBA (A Step-by-Step Guideline)

Jan 13, 2022 Macros & Excel VBA

Advanced Filter is one of the most important and widely used features that we use while working in Excel, as well as in Visual Basic Application ...

How to Use EoMonth in Excel VBA (5 Examples)

Jan 13, 2022 Macros & Excel VBA

In Microsoft Excel’s Visual Basic for Applications (VBA), there are a lot of built-in functions that can ease the ways of solving complex problems. ...

How to Use the VBA DatePart Function in Excel (7 Examples)

Jan 13, 2022 Macros & Excel VBA

One of the most important and widely used functions that we encounter while working with VBA is the DatePart function of VBA. Today in this article, ...

How to Use VBA AutoFill in Excel (11 Examples)

Jan 13, 2022 Excel Basics

Using autofill in Excel with VBA is a great tool to use while working with data that is repetitive or in a sequential pattern. Excel gives us several ...

How to Format Date with VBA in Excel (4 Methods)

Jan 11, 2022 Macros & Excel VBA

Implementing VBA macro is the most effective, quickest and safest method to run any operation in Excel. In this article, we will show you how to ...

Date Variable in VBA Codes (7 Uses of Macros with Examples)

Jan 13, 2022 Macros & Excel VBA

In Microsoft Excel's VBA, there are a lot of essential methods and functions. To use those, we have to declare variables. The Date variable is one of ...

How to Get the Current Date in VBA (3 Ways)

Jan 11, 2022 Macros & Excel VBA

In this article, I’ll show you how you can get the current date in VBA in Excel. You’ll learn to show the current date, show the current time, as ...

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

Jan 13, 2022 Macros & Excel VBA

In Excel, various people use different date formats so it is required to have any function to convert any formats into a standard date format. ...

The Day Function in Excel VBA: A Complete Guide with 3 Examples

Jan 13, 2022 Macros & Excel VBA

While working in Microsoft Excel Visual Basic for Applications (VBA), we may feel the necessity of using only the day value rather than the entire ...

How to Use the Mid Function of VBA in Excel (3 Examples)

Jan 10, 2022 Macros & Excel VBA

One of the most important and widely used functions that we use while working with VBA in Excel is the Mid function of VBA. It takes a string as the ...

How to Get the Day of Week Using VBA (4 Suitable Methods)

Jan 11, 2022 Macros & Excel VBA

The day of the week becomes worthwhile for planning, scheduling, and even financial analysis. In a previous article, I discussed how to use the ...