Home » Excel VBA Tutorials

Excel VBA Tutorials

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.

  1. Lesson 1 : Getting Started with Excel VBA
  2. Lesson 2 : Record Your First Macro And Run It
  3. Lesson 3 : Writing Your Own VBA Code - 35 Examples
  4. Lesson 4 : Playing with Dynamic Ranges in Excel
Excel VBA Tutorials
  1. ActiveWorkbook vs ThisWorkbook
  2. Excel VBA : IF THEN ELSE STATEMENT
  3. Excel VBA : Select Case Statement (Alternative to IF THEN ELSE)
  4. Excel VBA : Message Box
  5. Excel VBA : FOR - NEXT LOOP
  6. Excel VBA : User Defined Functions(UDFs)
  7. Excel VBA : Worksheet Functions
  8. Excel VBA : Find Last Used Row and Last Used Column
  9. Excel VBA : Find Last Visible Row
  10. Excel VBA : How to Concatenate
  11. Excel VBA : How to Remove Special Character
  12. VBA : How to Sort Data
  13. VBA : How to Filter Data
  14. VBA : How to Use NOT LIKE
  15. VBA : How to Use LIKE operator
  16. VBA : How to Use Wildcards
  17. VBA : How to Unhide One or Multiple Rows
  18. VBA : 4 Ways to Add Comment
  19. VBA : How to Unhide Columns
  20. VBA : How to Unhide Sheets
  21. VBA : How to Debug User Defined Function (UDF)
  22. VBA : How to Use For Each Loop
  23. VBA : How to Remove Duplicates
  24. VBA : Ways to Identify Duplicates
  25. VBA : How to Delete Rows
  26. VBA : How to Create Bar Chart
  27. VBA : How to Modify Axes in Chart
  28. VBA : How to Delete Charts
  29. VBA : How to List Open Workbooks
  30. VBA : Multiple Ways to Find Last Used Row
Excel Macros
  1. Convert Multiple Excel Files to PDF
  2. Convert Multiple PowerPoint Files into PDF with Excel VBA
  3. Filter Data Based on Drop Down Selection
  4. Filtering and Pasting Data to New Sheet
  5. Concatenate Text based on Criteria
  6. Calculating Partial Correlation Matrix with Excel VBA
  7. Excel UDF: Copy cell comment into another cell
  8. Excel UDF: Dependent cell comment
Spread the Word!
Share
Subscribe to: Posts (Atom)