VBA w/ Excel Macros

Course Description

Visual Basic for Applications (VBA) is an implementation of Microsoft's event-driven programming language Visual Basic 6, which was discontinued in 2008, and its associated integrated development environment (IDE). Although Visual Basic is no longer supported or updated by Microsoft, the VBA programming language was upgraded in 2010 with the introduction of Visual Basic for Applications 7 in Microsoft Office applications.

You will learn

  • Increasing productivity when working with Excel data by leveraging the power of VBA
  • Getting well-grounded in the language in preparation for Excel development while extending your general programming potential in other applicable Microsoft Office applications
  • Familiarization with the core objects in the Excel object model
  • Building solutions for conceptual and realistic problems into Excel

Course Outline

Unit 1:
  • Preliminary comments on VBA
  • Power and value of this language
  • Limits and restrictions of the standard Excel User Interface
  • Extending Excel’s built-in capabilities
  • Survey of general solutions
  • Visual Basic Editor (VBE)/Integrated Development Environment (IDE)
Unit 2:
  • Building code automatically/li>
  • The role of variables and constants
  • Data Types
  • Variable and procedure scopes
  • Enumerations
  • Arrays
  • Naming conventions
  • Object Browser
Unit 3:
  • Control flow – beyond linear execution
  • If…Then statement
  • For…Next statement
  • For each statement
  • Do loop statement
  • Select Case statement
  • Interacting with the user & collecting inputs
Unit 4:
  • Writing subroutines
  • Calling a subroutine
  • Creating code shells
  • Parameters to a procedure
  • ByRef and ByVal purposes
  • Writing functions
  • Calling functions
  • Terminating a program arbitrarily
  • Linking to external projects and libraries
Unit 5:
  • Workbooks object
  • Core members
  • Workbook object
  • Core members
  • Worksheet object
  • Core members
  • Range object
  • Core members
  • Error handling to boost program robustness
  • Trouble-shooting/Debugging
Unit 6:
  • User Form
  • As central I/O point
  • For improving Excel real estate
  • Consolidated controls
  • Guides decision making
  • Data validationsM
  • Providing choices to the user
  • Miscellaneous topics


No schedule yet, contact us for register, we will contact you when we have classes