The following tutorials describe a set of Excel VBA tutorials which are useful for learning basic, intermediate and advanced excel macros.
Automation is one of the key skill organisation look for. Excel Macros are used to automate repetitive tasks and Visual Basic for Application (VBA) is the programming language used for building excel macros.
Learn VBA Programming in 4 Lessons
These four lessons help you get started with the VBA language and provide a step-by-step approach to learning it from scratch. After completion of these lessons, you will be able to build macros.
- Lesson 1 : Getting Started with Excel VBA
- Lesson 2 : Record Your First Macro And Run It
- Lesson 3 : Writing Your Own VBA Code - 35 Examples
- Lesson 4 : Playing with Dynamic Ranges in Excel
Excel VBA Tutorials
- Excel VBA : IF THEN ELSE STATEMENT
- Excel VBA : Select Case Statement (Alternative to IF THEN ELSE)
- Excel VBA : Message Box
- Excel VBA : FOR - NEXT LOOP
- Excel VBA : User Defined Functions(UDFs)
- Excel VBA : Worksheet Functions
- Excel VBA : Find Last Used Row and Last Used Column
- VBA : How to Sort Data
- VBA : How to Use NOT LIKE
- VBA : How to Use LIKE operator
- VBA : How to Use Wildcards
- VBA : How to Unhide One or Multiple Rows
- VBA : How to Unhide Columns
- VBA : How to Unhide Sheets
- VBA : How to Debug User Defined Function (UDF)
- VBA : How to Use For Each Loop
- VBA : How to Remove Duplicates
- VBA : Ways to Identify Duplicates
- VBA : How to Create Bar Chart
- VBA : How to Modify Axes in Chart
- VBA : How to Delete Charts
- VBA : How to List Open Workbooks
- VBA : Multiple Ways to Find Last Used Row
Excel Macros
- Convert Multiple Excel Files to PDF
- Convert Multiple PowerPoint Files into PDF with Excel VBA
- Filter Data Based on Drop Down Selection
- Filtering and Pasting Data to New Sheet
- Concatenate Text based on Criteria
- Calculating Partial Correlation Matrix with Excel VBA
- Excel UDF: Copy cell comment into another cell
- Excel UDF: Dependent cell comment
Share Share Tweet