MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.


I'm not curious

A beginner’s and intermediate guide to VBA programming

Course Summary

Learn how to unlock the power of Microsoft's VBA programming language to build effective and powerful programs.


  • +

    Course Syllabus

    • Introduction
      • Download your working files first
      • What can you expect from this course
    • General overview
      • What is VBA?
      • Lessons learned
    • VBA editor - layout and basic functionality
      • General overview
      • File menu
      • Edit menu
      • View menu - Part 1
      • View Menu - Part 2
      • Insert menu
      • Format menu
      • Debug, Run, Tool & Window Menu
      • Example - Debugging code - Part 1
      • Example - Debugging code - Part 2
      • Progress check
    • Learn the basics of VBA programming
      • Variables
      • Example - Declaring and initializing variables
      • Example - Variable scope - Part 1
      • Example - Variable scope - Part 2
      • Constant variables
      • Functions & Procedures
      • Example - Passing & returning values - ByVal - Part 1
      • Example - Passing & return values - ByVal - Part 2
      • Example - Passing & returning Values (ByRef)
      • Example - Sub Procedures
      • IF statement
      • Example - IF statement
      • Example - IF statement (Continued)
      • Select Case Statement
      • Example - Select Case Statement
      • Loop Statements
      • Example - Loop Statements
      • Exit statement
      • Example - Exit Statement
      • Goto statement
      • Example - Goto statement
      • Enumeration statement
      • Example - Enumeration
      • DoEvents statement
      • Example - DoEvents
      • Error Handling
      • Macros
      • Arrays
      • Example - Arrays
      • Example - Arrays Advance - Part 1
      • Example - Arrays Advance - Part 2
      • Example - Arrays (Continued)
    • Excel Objects
      • General Overview
      • A practical example
    • Classes
      • Classes
      • Example - Classes - Example 1 - Part 1
      • Example - Classes - Example 1 - Part 2
      • Example - Classes - Example 1 - Part 3
    • String Manipulation
      • Overview
      • Example - String Manipulation - Example 1 - Part 1
      • Example - String Manipulation - Example 1 - Part 2
      • Example - String Manipulation - Example 1 - Part 3
      • Example - String Manipulation - Example 2 - Part 1
      • Example - String Manipulation - Example 2 - Part 2
    • Userforms
      • Example 1 - UserForm - Part 1
      • Example 1 - UserForm - Part 2
      • Example 2 - UserForm
      • Progress check
    • More advance examples
      • Example - Copy text down - Part 1
      • Example - Copy text down - Part 2
      • Example - Merge text - Part 1
      • Example - Merge text - Part 2
      • Example - Merge text - Part 3
      • Example - Remove values
      • Example - Access to text files - Part 1
      • Example - Access to text files - Part 2
      • Example - Remove duplicate values from arrays - Part 1
      • Example - Remove duplicate values from arrays - Part 2
      • Example - Classes - Part 1
      • Example - Class - Part 2
      • Example - Class - Part 3
    • Conclusion
      • Conclusion


Course Fee:
USD 10

Course Type:

Self-Study

Course Status:

Active

Workload:

1 - 4 hours / week

This course is listed under Development & Implementations and Data & Information Management Community

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
REDHERRING
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top