Macros & Excel VBA Archives - Page 69 of 70

How to use Excel VBA to Change the Case of Text – 6 Examples

Aug 15, 2024

Download Practice Workbook Download the practice workbook. Change Case of Selected Text Using VBA.xlsm To change the case of text in ...

How to use Excel VBA to Change the Case of Text – 6 Examples

How to Create Excel VBA UserForm: 14 Methods

May 30, 2024

Method 1 - Creating a Blank UserForm Go to the top ribbon, press on the Developer, and then press on the Visual Basic option from the menu. ...

How to Create Excel VBA UserForm: 14 Methods

How to Create a UserForm: an Overview

Nov 11, 2025

In many cases, it is adequate to use InputBox and MsgBox functions. Using InputBox function, a user can provide only a single input to Excel. So, to ...

How to Use MsgBox and InputBox in VBA Excel

Jul 31, 2024

Introduction to InputBox() Function Using the VBA InputBox() function, we can display an InputBox to users and request responses from them. This is ...

How to Use MsgBox and InputBox in VBA Excel

How to Use an Excel VBA Userform – 2 Examples

Aug 3, 2024

This is an overview. Creating Your Own UserForm You can develop a macro that works with different data in different circumstances, using ...

How to Use an Excel VBA Userform – 2 Examples

How to Create Custom Function in Excel VBA

Jul 23, 2024

Here's an overview of a custom function that was made via VBA code. As you can see, the function has lowercase letters, unlike traditional Excel ...

How to Create Custom Function in Excel VBA

How to Use the VBA Average Function in Excel – 4 Examples

Aug 15, 2024

Quick View: Function TopAverage(DataAvg, Num) 'Returns the average of the highest Num values in Data Sum = 0 For i = 1 To Num ...

How to Use the VBA Average Function in Excel – 4 Examples

How to Create a VBA Function with Arguments in Excel – 4 Examples

Aug 14, 2024

Example 1 - Creating a VBA Function with a Single Argument Create a function to convert Kg to Grams: Steps: Enter the following code in the ...

How to Create a VBA Function with Arguments in Excel – 4 Examples

How to Use VBA User Defined Function (4 Suitable Examples)

Jul 13, 2024

What Is a VBA User Defined Function? A user defined function is a custom function made by users according to their needs. It is a collection of ...

How to Use VBA User Defined Function (4 Suitable Examples)

How to Execute VBA Function Procedure in Excel (2 Easy Ways)

Jul 29, 2024

This article is part of a series: Excel VBA & Macros – A Step by Step Complete Guide. Method 1 - Calling Custom Functions from Procedure to ...

How to Execute VBA Function Procedure in Excel (2 Easy Ways)

How to Create Custom VBA functions and Use them in the Worksheet

Nov 11, 2025

This article is part of my series: Excel VBA & Macros – A Step by Step Complete Guide. We already know that there are two types of VBA macros ...

How to Create Custom VBA functions and Use them in the Worksheet

Difference Between Subroutine and Function in Excel VBA

Jul 19, 2024

There are lots of similarities between a custom Function/User-Defined Function procedure and the Sub-procedure/Subroutine in Excel. However, Function ...

Difference Between Subroutine and Function in Excel VBA

25 VBA Macro Example for Enhanced Productivity

Jul 12, 2024

How to Launch and Insert Code in the Visual Basic Editor in Excel The Developer tab contains the VBA applications including creating and recording ...

25 VBA Macro Example for Enhanced Productivity

How to Use VBA Conditional Statements in Excel (4 Examples)

Jul 29, 2024

This article is part of a series: Excel VBA & Macros – A Step by Step Complete Guide Download Practice Workbook VBA Conditional ...

How to Use VBA Conditional Statements in Excel (4 Examples)

List of 10 Mostly Used Excel VBA Objects (Attributes & Examples)

Jul 31, 2024

This article is part of the series: Excel VBA & Macros – A Step by Step Complete Guide. Download Practice Workbook VBA Objects.xlsm ...