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
Schedule
No schedule yet, contact us for register, we will contact you when we have classes
