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

Visual Basic for Excel - Microsoft VBA Excel Tutorial

Course Summary

Master Visual Basic for Excel, learn to unlock the true power of Excel. Tutorial Taught by a leading Microsoft Expert

  • +

    Course Syllabus

    • Getting Started
      • Working Files - Download These First
      • What Will I Get Out Of This Course
      • The Excel Working Files Explained
      • How to obtain your Certificate of Completion for this Infinite Skills course.
      • What Is VBA For Excel?
      • Excel 2010 Security Settings And Macro Files
      • The Developer Ribbon
    • Macros
      • Recording And Running A Simple Macro
      • Editing An Existing Macro In The Visual Basic Editor
      • The New Macro Enabled File Type
      • Quick Tour Of The Excel Visual Basic Editor
      • Watch A Macro Write Your VBA
    • Procedures And Functions
      • What Is A Module?
      • Creating A Sub Procedure Manually
      • How To Call A Sub Procedure
      • Creating A Function Procedure
      • How To Call A Function
    • Getting Started With VBA Programming
      • Using Comments Within Your VBA Code
      • Declaring Variables And Data Types
      • The Scope Of A Variable
      • The Static Declaration And Variable Expiry
      • Constants Instead Of Variables
      • An Intrinsic Constant
      • String And Date Types Expanded
      • Excel VBA Operators
      • Arrays
      • Multi-Dimensional Arrays
      • Dynamic Arrays
    • Manipulating Excel Objects
      • Referencing Cells Using The Range Object
      • The CELLS Property
      • The OFFSET Property
      • The VALUE Of Ranges
      • The TEXT Object Of The RANGE
      • A Number Of Read Only RANGE Properties
      • The FONT Property And Colors
      • Formatting Numeric Values
      • Add Formulas To Cells Through VBA Code
      • Common METHODS Of The RANGE Object
    • Working With Excel VBA Functions
      • What Is A Function?
      • Built In VBA Date Functions
      • Text Manipulation With VBA Functions
      • Determining File Sizes Using FILELEN
      • Using Worksheet Excel Functions In VBA Code
      • User Defined Functions In Excel
    • Controlling Program Flow And Execution
      • Using GOTO And Labels
      • Controlling The Program Flow With IF THEN ELSE
      • Multiple Criteria Plus Nested IFs
      • Adding ELSEIF To Speed Up Execution
      • SELECT CASE As An Alternative To IF
      • The FOR NEXT Loop
      • FOR NEXT With A VBA Collection
      • DO WHILE Loop
    • Events
      • How To Create An Event
      • WorkBook Events - Open
      • Workbook Events - Closing And Saving
      • Workbook Triggers - Activate And Deactivate
      • Worksheet Triggers - Activate And Deactivate
      • Other Useful Worksheet Triggers
      • Using Application Events
    • Debugging And Error Handling
      • Error Trapping the Easy Way
      • Make The VBA Ignore Errors
      • Interact With The User When An Error Occurs
      • Making Use Of The ERR Object
      • Debugging Techniques
      • Using Breakpoints To Help Debug
      • Setup And Use A Watch
      • Speeding Up The VBA Tips
    • Interacting With Users Through Forms
      • Using MSGBOX To Interact With Users
      • Use INPUTBOX For Accepting Values From Users
      • Selecting A Range With The INPUT Box
      • An Introduction To UserForms
      • Creating A UserForm
      • Using Command Buttons In Excel
      • Adding Option Buttons In A Frame
      • Adding The Code That Makes The Form Work
      • Calling Your UserForm And Validating Content
      • UserForm Controls - The CheckBox
      • UserForm Controls - ListBox And/Or Combo Box
      • Images On UserForms
      • Labels And Text Boxes
      • Multiple Tabs On A UserForm
      • Allowing The User To Highlight A Range
      • Scrollbar And Spin Controls
      • Controlling Tab Order And Aligning Controls
    • Running And Storing VBA Code
      • Trigger A Procedure From The Quick Access Toolbar
      • Customizing The Ribbons
      • Adding Buttons To Sheets
      • Adding A Keyboard Shortcut Trigger
      • Where To Store Your VBA Code
      • Adding Code To The PERSONAL File
    • Summary
      • So What's Next?

Course Fee:
USD 99

Course Type:


Course Status:



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
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