The following links describe a set of Excel VBA tutorials which are useful for learning basic, intermediate and advanced excel macros. These tutorials would help you to automate daily repetitive tasks which would result in operational efficiency improvement for the organisation. Automation is one of the key skill organisation look for. Excel Macros are powerful in nature and Visual Basic for Application (VBA) is the programming language used for building excel macros. These tutorials provide you step by step approach in learning VBA from scratch.
Learn VBA Programming in 4 Lessons
These 4 lessons help you to get started with VBA language. After completion of these lessons you will have a fair idea about VBA and will be able to build macros for automation.
- 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
- Excel VBA : How to debug a user defined function (UDF)
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