Macros & Excel VBA Archives - Page 32 of 50

How to Convert Text to Date with Excel VBA – 5 Methods

Aug 9, 2024

The sample dataset contains text values. Method 1 -Using the CDATE Function to Convert Text to Date with Excel VBA 1.1 Convert a Text ...

How to Convert Text to Date with Excel VBA – 5 Methods

How to Format Numbers in Decimal Places Using Excel VBA (6 Methods)

Jul 22, 2024

Dataset Overview We’ll work with a dataset containing columns for Rank, Chocolate Name, and Price ($). Method 1 - Formatting Integers Up ...

How to Format Numbers in Decimal Places Using Excel VBA (6 Methods)

How to Populate a Mail Merge Document from Excel with a VBA Macro

Jul 12, 2024

Scenario In the following image we have an email format in the Home sheet of our Excel workbook. There is another sheet named Info in our ...

How to Populate a Mail Merge Document from Excel with a VBA Macro

Excel VBA: Format Number with Comma (2 Examples)

Jul 4, 2024

How to Write Code in the Visual Basic Editor Go to the Developer tab from the Excel Ribbon. Click the Visual Basic option. In the ...

Excel VBA: Format Number with Comma (2 Examples)

How to Hide Formula in Excel Using VBA: 4 Methods

Jun 5, 2024

Method 1 - Embed VBA to Hide the Formula of a Range in Excel Steps to Protect a Sheet: Go to the tab Review. Click Protect Sheet from the ...

How to Hide Formula in Excel Using VBA: 4 Methods

VBA INDEX MATCH Based on Multiple Criteria in Excel (3 Methods)

Jun 20, 2024

This is the sample dataset for illustration. We will extract a certain result residing in one column based on conditions from the other two columns. ...

VBA INDEX MATCH Based on Multiple Criteria in Excel (3 Methods)

How to Insert Picture from URL Using VBA in Excel (2 Methods)

May 23, 2024

We will use the sample dataset below to insert images into the blank column (Image column) from the URLs given in the URL column. Method 1 - ...

How to Insert Picture from URL Using VBA in Excel (2 Methods)

How to Insert an Image into a Cell with Excel VBA (2 Methods)

May 15, 2024

Quick View Sub Insert_Single_Image() Image_Name = "Argentina" Image_Location = "E:\ExcelDemy\National Flags" Image_Format = ".png" ...

How to Insert an Image into a Cell with Excel VBA (2 Methods)

Using VBA to Select a Value from a Drop Down List in Excel – 2 Methods

Aug 3, 2024

Creating a Dropdown List from a Generic List in Excel In the dataset below, there are repeated values (Apple in B7 and B9) . Create a ...

Using VBA to Select a Value from a Drop Down List in Excel – 2 Methods

Excel VBA: Inserting a Picture from the Folder – 3 Methods

Aug 7, 2024

You have pictures in a specific folder and want to insert one of these pictures in your Excel worksheet. Go to the Developer tab. ...

Excel VBA: Inserting a Picture from the Folder – 3 Methods

Excel VBA: Create a UserForm Image from a Worksheet – 3 Examples

Aug 10, 2024

Example 1 - Using the Copy Pasting Tool You have an image in your worksheet. To add this image to the UserForm dialog box: ...

Excel VBA: Create a UserForm Image from a Worksheet – 3 Examples

How to Keep Unique Values in a Drop Down List with Excel VBA – 3 Methods

Aug 13, 2024

Quick View: Sub Drop_Down_List_Unique_Values_At_Least_Once() List_Location = "B3" Data = Range(List_Location).Validation.Formula1 Data = ...

How to Keep Unique Values in a Drop Down List with Excel VBA – 3 Methods

Excel VBA: Dynamic Range Based on Cell Value (3 Methods)

Jul 23, 2024

How to Write Code in the Visual Basic Editor Go to the Developer tab from the Excel Ribbon. Click the Visual Basic option. In the ...

Excel VBA: Dynamic Range Based on Cell Value (3 Methods)

How to Count Columns with Data Using Excel VBA (2 Methods)

Jul 15, 2024

Method 1 - Count All the Columns with Data in a Worksheet Open the VBA editor by pressing ALT + F11. Create a new module from Insert > ...

How to Count Columns with Data Using Excel VBA (2 Methods)

How to Find and Replace Multiple Values in Excel with VBA (3 Examples)

Jun 11, 2024

Below is a dataset that contains information about the departments of employees. We will try to use VBA to find and replace the department's values. ...