Macros & Excel VBA Archives - Page 13 of 70

Excel VBA to Declare Multidimensional Array of Unknown Size

Nov 11, 2025

In Excel VBA, multidimensional arrays are a powerful tool for handling complex data structures. They allow you to store and manipulate data in a way ...

Excel VBA to Declare Multidimensional Array of Unknown Size

Excel VBA Multidimensional Arrays

Nov 11, 2025

If you’re thinking about storing multiple data against a common entry, a multidimensional array can serve the need. Multidimensional Arrays are ...

Excel VBA Multidimensional Array for Assigning Values (6 Ways)

Jul 22, 2024

How to Launch the VBA Editor in Excel Go to the Developer tab and select Visual Basic under Code. Alternative command: Pressing Alt + F11 ...

Excel VBA Multidimensional Array for Assigning Values (6 Ways)

Excel VBA Sort Range with Multiple Keys

Nov 11, 2025

On day-to-day tasks, you may have to use the Excel VBA to sort range with multiple keys. You can do it quite easily with the help of ...

Using Excel VBA to Sort in Descending Order – 6 Examples

Aug 2, 2024

How to Launch the VBA Editor in Excel Utilizing the Module Tool: Open your workbook and select Visual Basic in the Developer tab. ...

Using Excel VBA to Sort in Descending Order – 6 Examples

Excel VBA: Input Box with Options

Jun 11, 2024

The Basic Syntax of an Input Box in Excel VBA The basic Syntax of an inputbox is given below: InputBox(Prompt, Title, Default, XPos, YPos, ...

Excel VBA: Insert Row with Values: 4 Examples

May 21, 2024

Method 1 - Insert Single Row with Values Use an Excel VBA code to insert a single row with values into a dataset that contains student names and ...

Excel VBA: Insert Row with Values: 4 Examples

Excel VBA: InputBox Type with Examples

Jul 22, 2024

Here's an overview of various types of inputs in an InputBox. Overview of an Excel VBA InputBox Using the VBA InputBox() function, we can ...

Excel VBA: InputBox with Password Mask (2 Examples)

Jul 3, 2024

How to Launch a VBA Editor in Excel To launch the VBA Editor, click on the Developer Tab from Excel Ribbon and select the Visual Basic option. If ...

Excel VBA: InputBox with Password Mask (2 Examples)

How to Get an Excel VBA Input Box with a Drop-Down List: 2 Methods

May 14, 2024

The image below shows an input box with a drop-down list of names. How to Launch VBA Macro Editor in Excel To run a VBA code, we first ...

How to Get an Excel VBA Input Box with a Drop-Down List: 2 Methods

Excel VBA InputBox with Multiple Lines (3 Examples)

Jun 15, 2024

Here is an image overview of using a constant (vbNewLine or vbCr) of the InputBox function that allows multiple lines in the InputBox. This InputBox, ...

Excel VBA InputBox with Multiple Lines (3 Examples)

How to Delete Row with VBA and Shift Up Cells in Excel (11 Examples)

Jul 13, 2024

When working with large Excel worksheets, cleaning unnecessary data is essential. Deleting specific rows and shifting the remaining ones up to close ...

How to Delete Row with VBA and Shift Up Cells in Excel (11 Examples)

How to Handle VBA InputBox Cancel Button in Excel: 2 Methods

May 25, 2024

1. Use StrPtr Function & If ElseIf Statement to Show If User Clicked Cancel Button in VBA Inputbox Insert the following code into your ...

How to Handle VBA InputBox Cancel Button in Excel: 2 Methods

VBA MsgBox Format in Excel – 5 Examples

Aug 10, 2024

What Is an Excel VBA MsgBox? The Excel VBA MsgBox is a built-in function in Microsoft Excel's Visual Basic for Applications (VBA) programming ...

Excel VBA: Delete Row on Another Sheet

Nov 11, 2025

Looking for ways to delete rows on another sheet using Excel VBA? Then, this is the right place for you. Deleting rows in Excel using VBA can be a ...