Macros & Excel VBA Archives - Page 9 of 50

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: InputBox Date Format: 6 Methods

May 27, 2024

Method 1 - Using VBA IsDate and CDate Functions for Date Format Validation Show how to take date-type data in any format with InputBox, convert ...

Excel VBA: InputBox Date Format: 6 Methods

Excel VBA to Cancel Selection: 5 Suitable Methods

Jun 25, 2024

Method 1 - Using VBA Application.CutCopyMode Property to Cancel Selection While Copying When you copy the values from some range in Excel with ...

Excel VBA to Cancel Selection: 5 Suitable Methods

Excel VBA to Sort Multidimensional Array: 2 Methods

Jul 3, 2024

Method 1 - Creating Multidimensional Array and Then Sorting Create a random, unsorted dataset with the data we imputed in the array. We took 5 ...

Excel VBA to Sort Multidimensional Array: 2 Methods

Pop Up Excel VBA MsgBox When Cell Meets Criteria

Jul 24, 2024

How to Launch the VBA Editor in Excel You need the Developer tab to display on your ribbon. If you don’t have it, check how to enable the ...

Pop Up Excel VBA MsgBox When Cell Meets Criteria

How to Use VBA Methods in Excel to Wait Milliseconds between Code Execution (3 Ways)

Jul 2, 2024

How to Launch VBA Editor in Excel You can easily launch the VBA editor by pressing Alt+F11 or using the Visual Basic command from the ...

How to Use VBA Methods in Excel to Wait Milliseconds between Code Execution (3 Ways)

Excel VBA to Display Message Box for 5 Seconds

Jun 15, 2024

There are various ways to display messages for 5 seconds using VBA in Excel. In the video below, we use VBA code to display a MsgBox for five seconds ...