|
|
Microsoft Excel Level 5
VBA Programming Introduction
Aims
This course is aimed at people who wish to make a start at learning the Excel VBA programming language, familiarising themselves with the concepts and practice of VBA programming, and understanding and using the relevant techniques.
Prerequisites
Students who wish to attend this course need to have significant experience and ability at understanding and using Excel advanced functionality.
Objectives
On completion of this course delegates will be able to:
-
Use the Macro Recorder
-
Understand how VBA code is stored and how to access it using the Visual Basic Editor
-
Launch the Visual Basic Editor and use it to manage module sheets and code
-
Get macros to run via shortcut keys, menus and buttons
-
Write simple sub procedures with frequently used Excel objects, methods and properties
-
Create decision-making code
-
Use the Do and While loop to repeat the execution of code
-
Use simple variables to store and return information in a sub procedure
Course Content
Recording Macros
-
What is a macro?
-
Recording a Macro
-
Running a Macro
-
Recording a Macro Using Relative References
-
Saving a Workbook Containing a Macro
-
Opening a Workbook Containing a Macro
-
Saving the Personal Macro Workbook
The Visual Basic Editor
-
Launching the Visual Basic Editor
-
Navigating the Visual Basic Editor
-
Finding a Macro in the Visual Basic Editor
-
Inserting a Module into a Workbook
-
Copying a Module between Workbooks
-
Renaming a Module Sheet
-
Deleting a Module Sheet
-
Importing and Exporting Code as Text
Assigning Macros
-
Running a Macro with Shortcut Keys
-
Adding Custom Buttons to Run a Macro
-
Removing Custom Buttons
-
Creating and Editing a Worksheet Macro Button
|
Writing procedures
-
Frequently Used Excel Objects (Range, WorkSheets, WorkBooks)
-
Methods and Properties
-
Adding Arguments to Methods
-
Selection or ActiveCell?
-
Writing VBA Sub Procedures
-
The With ... End With Block
-
The Offset Property
-
Dealing with a Runtime Error
-
Using the Object Browser
Control Structures
-
The If - Then Control Structure
-
The If – Then - Else Control Structure
-
Using ElseIf in a Control Structure
-
The Select Case Control Structure
-
Using a Do - Loop Statement
Data Variables
-
What are Data Variables?
-
Creating Data Variables and Assigning Values
-
The DIM statement
-
Data Variable Types
-
Using a Message Box to Return a Value
|
Click to expand...
Perfect Partners
Other courses which naturally complement this course include:
Next Learning Step
|
The next course in this series is:
|
|
|
Duration: 1 day(s)
.jpg)
Add to Favourites