Understand the VBA objects and procedures Essential VBA Language Elements
Knowledge Upon completion of today’s session, the student will: Understand the VBA objects and procedures Essential VBA Language Elements Skill Upon completion of today’s session, a student will be able to: Execute Sub Procedure and Function Work with Variables and Arrays Use labels and comments in VBA code Introducing the Excel Object Model Object Properties, Methods, Events VBA Sub and Function Procedure Executing Sub procedure Executing Function Procedure Essential VBA Language Elements Using Variables, Constants and Data Types Using Assignment Statements Working with Arrays Using Label Using Comments in VBA code Lab work Lesson 4.1 VBA Object and Procedures Excel Is an Object? You’ve used Excel for quite a while, but you probably never thought of it as an object. The more you work with VBA, the more you view Excel in those terms. You’ll understand that Excel is an object and that it contains other objects. Those objects, in turn, contain still more objects. In other word...