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

Excel 2007 VBA

Course Summary

Power up your workbooks with Visual Basic for Applications automation


  • +

    Course Syllabus

    • Introduction
      • Introduction
    • Understanding the Excel Object Model
      • Understanding Objects
      • Referencing Workbooks, Worksheets, and Cells
    • Creating Recorded Macros
      • Displaying the Developer Tab
      • Setting Macro Trust within Excel
      • Recording a Macro
      • Running a Macro
      • Editing a Macro with the Visual Basic Editor
    • Understanding the Visual Basic Editor
      • Examining the VBA Editor Menu and Toolbar
      • Setting VBA Editor Options
      • Reviewing the Project Explorer
      • Reviewing the Properties Window
      • Understanding the Object and Procedure drop-down lists
      • Viewing the Immediate Window
      • Viewing the Object Browser
    • Understanding Programming Basics
      • Understanding Functions and Procedures
      • Dimensioning Variable
      • Understanding Object Variables
      • Understanding Variables and Scope
      • Commenting your Code
      • Creating Constants
      • Manipulating Data
      • Understanding Procedure Arguments
    • Using Visual Basic Functions
      • Using the InputBox() Function
      • Understanding the MsgBox() Function
      • Using String Functions
      • Using Date Functions
    • Working with Control Structures
      • Using If/Then/Else
      • Creating a Select/Case Statement
      • Understanding Logical Operators
      • Creating For/Next Loops
      • Creating Do Loops
      • Creating While/Wend Loops
    • Creating UserForms
      • Understanding UserForms
      • Understanding Controls
      • Setting Control Properties
      • Referencing Controls in VBA Code
      • Responding to Events
      • Creating a function to open a UserForm
      • Development Tips
    • Debugging your Macros
      • Understanding Logic Errors and Syntax Errors
      • Running your Macro from the VBA Editor
      • Setting Breakpoints
      • Stepping Through Your Macro
      • Creating Watches
      • Adding Error Trapping
    • Conclusion
      • Conclusion


Course Fee:
USD 40

Course Type:

Self-Study

Course Status:

Active

Workload:

1 - 4 hours / week

This course is listed under Development & Implementations Community

Related Posts:

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