Course not currently available
Microsoft Excel VBA Introduction
Training
In Fareham ()
Description
-
Type
Training
-
Level
Beginner
-
Duration
2 Days
By the end of this level you will be able to: Understand the basics of a Visual Basic Module Understand how to execute one or more lines of code repetitively Understand relative and absolute recorded macros, and assign these macros to various objects Create macros that interact with the user Create custom functions Analyze how your code operates and locate the source of errors Write procedures that test conditions and then run only certain statements based on the results. Suitable for: This is an introduction to VBA programming. It will be useful for students to understand Excel as a user before comming on the course.
About this course
The course is aimed at new users to VBA. No specific experience with VBA is required but delegates should be proficient in the use of Excel. Some programming experience would be helpful but is not essential.
Reviews
Course programme
Microsoft Excel VBA
Introduction to Microsoft Excel VBA
You will learn how to create and edit macros, and gain a good understanding of VBA code.
Content
- Section 1 Introduction - Recording Macro's - Running a Macro - Absolute & relative References
- Section 2 Assigning Macro's - Assigning to a Button - Assigning to the Toolbar
- Section 3 Editing Macro's - Editing a Macro - The VBA Environment
- Section 4 An Introduction to VBA - An Introduction to Objects, Properties, Methods and Events - An Introduction to VBA Procedures, Functions and Classes - An Introduction to Modules, Forms and Event Procedures - The VBA Object Browser
- Section 5 Programming in VBA - Creating a simple procedure - Using VBA Functions - VBA Branching Commands - Passing Arguments to functions & procedures - VBA Control Structures - Creating & Using Variables - Creating & Using Constants - Creating & Using Static Arrays - Creating & Using Dynamic Arrays
- Section 6 The Range Object - The Cells property - The Range property - Flexible Ranges
- Section 7 Workbook & Worksheets - Activating Workbooks - Activating Worksheets - This workbook - Workbook & Worksheet Events
- Section 8 Custom & Built in Forms - Built In Dialogue Boxes - Creating User - defined Forms - Using User Defined Forms - User defined Toolbars & menus
- Section 9 Handling Errors in VBA - Using the VBA Debugger - Trapping Errors - Using the ERR Object
Course Includes: Lunch/refreshments and course materials.
Microsoft Excel VBA Introduction