Excel VBA Function

How to Use VBA LCase Function in Excel (3 Easy Examples)

When working in VBA, we often need to convert certain strings into lowercase, uppercase, or proper case strings. In this article, we will talk about ...

How to Use VBA SPLIT Function in Excel (10 Ideal Examples)

How to Launch the VBA Editor in Excel If you don’t see the Developer tab, enable the Developer tab. Select the Developer tab and click on ...

How to Use the VBA Trim Function in Excel – 5 Examples

This is an overview. The VBA TRIM Function Summary The Trim function in VBA removes the leading and trailing spaces from a ...

How to Use VBA Asc Function (5 Practical Examples)

Download Practice Workbook VBA Asc Function in Excel.xlsm Introduction to VBA Asc Function The VBA Asc function is a built-in function ...

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

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 ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo