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

Ultimate Excel VBA

Course Summary

Programming for the Business Professional


  • +

    Course Syllabus

    • Introduction
      • Course Overview
      • Macro Recording Basics
      • The VBA Editor
      • Macro Recorder and the VBA Editor
    • The Excel Object Library
      • VBA & The Object Library
      • Objects and Properties
      • Objects and Methods
      • More about Objects and Properties
      • Referencing a Range
      • Important Range Properties
      • The Worksheets Collection
      • The Workbooks Collection
      • Exploring the Object Library
      • The Excel Object Library
    • The VBA Language
      • Simple Input & Output
      • Variables & Data Types
      • Object Type Variables
      • VBA & Worksheet Functions
      • User-Defined Functions
      • Branching: IF...THEN
      • Branching: SELECT...CASE
      • Looping: DO...LOOP
      • Looping: FOR...NEXT
      • Looping: FOR...EACH
      • Variable Scope
      • Error Handling
      • Project 1 - The VBA Language
      • The VBA Language
    • Launching Macros: Events & Shortcuts
      • Macro Launching Shortcuts
      • Modifying the Ribbon
      • Workbook & Worksheet Events
      • Application Events
      • Project 2 - Event Handling
      • Launching Macros: Events & Shortcuts
    • Modifying the User Interface
      • Enhanced Message Box
      • ActiveX & The Worksheet (No Code)
      • ActiveX & The Worksheet (With Code)
      • Basic User Forms
      • Project 3 - User Forms & ActiveX
      • Modifying the User Interface
    • What's Next?
      • Reaching Beyond Excel


Course Fee:
USD 99

Course Type:

Self-Study

Course Status:

Active

Workload:

1 - 4 hours / week

This course is listed under Development & Implementations Community

Related Posts:

VBA

 

ActiveX

 

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