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

Up and Running with VBA in Excel

Course Summary

Introduces object-oriented programming and shows how to automate routine tasks and provide custom functionality to enhance the features in Excel.       

  • +

    Course Syllabus

            Using the exercise files
        1. Introducing Visual Basic for Applications (VBA)
            Introducing object-oriented programming
            Examining the Excel object model
            Working in the Visual Basic editor
            Setting VBA project properties
            Creating, exporting, and deleting code modules
            Creating a subroutine or function
            Controlling procedure scope and visibility
            Adding comments to the code
            Running a VBA routine
            Adding code to a recorded macro
        2. Defining Variables, Constants, and Calculations
            Introducing Excel VBA data types
            Declaring variables and requiring declaration before use
            Managing variable scope
            Defining static variables and constants
            Creating a calculation using mathematical operators
            Defining arrays
            Defining and using object variables
            Streamlining code references using With...End With statements
        3. Adding Logic to Your VBA Code
            Repeating a task using a For...Next loop
            Stepping through all items of a collection using a For...Each loop
            Repeating a task with a Do loop
            Performing a task when conditions are met using If...Then
            Selecting which action to take using a Case statement
        4. Debugging Your VBA Code
            Managing errors using On Error statements
            Stepping through a subroutine or function
            Setting breakpoints in the code
            Verifying output using the Immediate window
            Watching a value in a routine
        5. Managing Workbook Elements and Data in VBA
            Writing a value to a cell
            Cutting, copying, and pasting cell data
            Finding values in cells
            Referring to cells using the Offset function
            Concatenating text strings
            Returning part of a string
            Managing worksheets with VBA
            Managing workbooks with VBA
        6. Adding Advanced Elements to Your Workbook
            Turning off screen updating within a macro
            Using worksheet functions in a macro
            Acquiring values using an input box or message box
            Calling a subroutine from another subroutine
        7. Using Excel Events in Your VBA Code
            Running a procedure when you open, close, or save a workbook
            Running a procedure when a cell range changes
            Triggering a procedure using a specific key sequence
        8. Putting It All Together
            Applying techniques in a Capstone project


Course Fee:
USD 25

Course Type:


Course Status:



3 - 4 hours / week

This course is listed under Development & Implementations Community

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
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