Macros & Excel VBA Archives - Page 3 of 50

Excel VBA to Call Sub with Parameters (3 Suitable Examples)

Jul 7, 2024

If you want to learn Visual Basic for Applications (Excel VBA), one of the most important concepts to know is Subroutines with parameters and how to ...

Excel VBA to Call Sub with Parameters (3 Suitable Examples)

Using the Excel VBA Function to Return Multiple Values – 6 Methods

Jun 3, 2024

The image below showcases how three results can be obtained, using the ByRef argument in the Excel VBA function. Method 1 - Returning ...

Using the Excel VBA Function to Return Multiple Values – 6 Methods

How to Define a Global Array in Excel VBA – 2 Methods

Jul 6, 2024

This is an overview. What Is a Global Array in Excel? In VBA (Visual Basic for Applications), a global array is an array that is declared ...

How to Define a Global Array in Excel VBA – 2 Methods

How to Use the Excel VBA Textbox to Format Dates (4 Methods)

Jul 27, 2024

When working with UserForms in Excel VBA, it is often necessary to format the date values displayed in TextBox controls for a better user experience. ...

How to Use the Excel VBA Textbox to Format Dates (4 Methods)

Excel VBA Declare Global Variable and Assign Value: 2 Ways

Jun 13, 2024

Method 1 - Declare Global Variable and Assign Value in VBA There are numerous advantages to using Global variables. We will address the issues ...

Excel VBA Declare Global Variable and Assign Value: 2 Ways

Excel VBA to Select Last Row

Jul 2, 2024

In Excel, if we need to add a new row after the last row in a large dataset, it can become tedious and time-consuming to go to the last row. Although ...

Activeworkbook Refreshall Not Working [Solved!]

Jul 23, 2024

Excel VBA Refresh All Open Workbooks The ActiveWorkbook.RefreshAll method is used to refresh all the existing data connections and pivot tables in a ...

Activeworkbook Refreshall Not Working [Solved!]

How to Use the Excel VBA INDEX MATCH Function in Another Worksheet – 3 Methods

Jul 6, 2024

This is an overview: The sample dataset showcases Names. Date and Quantity sold. The dataset is in sheet1 and the result sheets are sheet2 ...

How to Use the Excel VBA INDEX MATCH Function in Another Worksheet – 3 Methods

How to Use Excel VBA Text to Columns Date Format (2 Examples)

Jun 14, 2024

The article demonstrates how to create a VBA macro that automates the Text to Columns process and converts text dates into Excel date format. ...

How to Use Excel VBA Text to Columns Date Format (2 Examples)

Using Excel VBA to Format a Number with a Leading Zero – 4 Methods

Jul 5, 2024

How to Launch the VBA Editor in Excel Enable the Developer tab on your ribbon. Go to the Developer tab. Select Visual Basic. ...

Using Excel VBA to Format a Number with a Leading Zero – 4 Methods

Loop Through Excel Files in Folder with VBA: 5 Suitable Examples

Jul 8, 2024

Method 1 - Loop Through Excel Files in Folder by Dir Function The Dir function in VBA retrieves the name of a file or folder that matches a ...

Loop Through Excel Files in Folder with VBA: 5 Suitable Examples

Different Cases That Will Teach You to Work with a Variable in Excel VBA MsgBox: 5 Methods

May 22, 2024

Method 1 - MsgBox with Improper Variable Type Declaration While working in Excel VBA, we encounter various errors. Run-time error ‘13’ occurs ...

Different Cases That Will Teach You to Work with a Variable in Excel VBA MsgBox: 5 Methods

How to Filter ComboBox Data in Excel VBA

Jun 11, 2024

A ComboBox allows users to select from a list of predefined items. However if the list is too big, It may become difficult to find a required item. ...

How to Filter ComboBox Data in Excel VBA

How to Use Target Address in Excel VBA (3 Examples)

May 18, 2024

The sample dataset contains the production and selling prices of different mobile phones. We are going to use Target.Address to change cell ...

How to Use Target Address in Excel VBA (3 Examples)

How to Use the VBA Input Box with Buttons in Excel – 2 Examples

Jun 27, 2024

Introduction to the Input Box in Excel The Input Box is a dialog box that takes input from the users. It has two buttons: OK and Cancel. ...