Warning: Parameter 2 to plgContentEmailCloak() expected to be a reference, value given in /home/ashbeeco/public_html/libraries/joomla/event/dispatcher.php on line 136

Warning: Parameter 2 to plgContentLoadModule() expected to be a reference, value given in /home/ashbeeco/public_html/libraries/joomla/event/dispatcher.php on line 136

Warning: Parameter 2 to plgContentPagebreak() expected to be a reference, value given in /home/ashbeeco/public_html/libraries/joomla/event/dispatcher.php on line 136

Warning: Parameter 2 to plgContentEmailCloak() expected to be a reference, value given in /home/ashbeeco/public_html/libraries/joomla/event/dispatcher.php on line 136

Warning: Parameter 2 to plgContentLoadModule() expected to be a reference, value given in /home/ashbeeco/public_html/libraries/joomla/event/dispatcher.php on line 136

Warning: Parameter 2 to plgContentPagebreak() expected to be a reference, value given in /home/ashbeeco/public_html/libraries/joomla/event/dispatcher.php on line 136

Warning: Parameter 2 to plgContentNavigation() expected to be a reference, value given in /home/ashbeeco/public_html/libraries/joomla/event/dispatcher.php on line 136

Warning: Parameter 2 to plgContentVote() expected to be a reference, value given in /home/ashbeeco/public_html/libraries/joomla/event/dispatcher.php on line 136

Warning: Parameter 2 to plgContentEmailCloak() expected to be a reference, value given in /home/ashbeeco/public_html/libraries/joomla/event/dispatcher.php on line 136

Warning: Parameter 2 to plgContentLoadModule() expected to be a reference, value given in /home/ashbeeco/public_html/libraries/joomla/event/dispatcher.php on line 136

Warning: Parameter 2 to plgContentPagebreak() expected to be a reference, value given in /home/ashbeeco/public_html/libraries/joomla/event/dispatcher.php on line 136

Warning: Parameter 2 to plgContentNavigation() expected to be a reference, value given in /home/ashbeeco/public_html/libraries/joomla/event/dispatcher.php on line 136

Warning: Parameter 2 to plgContentVote() expected to be a reference, value given in /home/ashbeeco/public_html/libraries/joomla/event/dispatcher.php on line 136

Warning: Parameter 2 to plgContentEmailCloak() expected to be a reference, value given in /home/ashbeeco/public_html/libraries/joomla/event/dispatcher.php on line 136

Warning: Parameter 2 to plgContentLoadModule() expected to be a reference, value given in /home/ashbeeco/public_html/libraries/joomla/event/dispatcher.php on line 136

Warning: Parameter 2 to plgContentPagebreak() expected to be a reference, value given in /home/ashbeeco/public_html/libraries/joomla/event/dispatcher.php on line 136

Warning: Parameter 2 to plgContentNavigation() expected to be a reference, value given in /home/ashbeeco/public_html/libraries/joomla/event/dispatcher.php on line 136

Warning: Parameter 2 to plgContentVote() expected to be a reference, value given in /home/ashbeeco/public_html/libraries/joomla/event/dispatcher.php on line 136

Warning: Parameter 2 to plgContentEmailCloak() expected to be a reference, value given in /home/ashbeeco/public_html/libraries/joomla/event/dispatcher.php on line 136

Warning: Parameter 2 to plgContentLoadModule() expected to be a reference, value given in /home/ashbeeco/public_html/libraries/joomla/event/dispatcher.php on line 136

Warning: Parameter 2 to plgContentPagebreak() expected to be a reference, value given in /home/ashbeeco/public_html/libraries/joomla/event/dispatcher.php on line 136

Warning: Parameter 2 to plgContentNavigation() expected to be a reference, value given in /home/ashbeeco/public_html/libraries/joomla/event/dispatcher.php on line 136

Warning: Parameter 2 to plgContentVote() expected to be a reference, value given in /home/ashbeeco/public_html/libraries/joomla/event/dispatcher.php on line 136

Warning: Parameter 2 to plgContentEmailCloak() expected to be a reference, value given in /home/ashbeeco/public_html/libraries/joomla/event/dispatcher.php on line 136

Warning: Parameter 2 to plgContentLoadModule() expected to be a reference, value given in /home/ashbeeco/public_html/libraries/joomla/event/dispatcher.php on line 136

Warning: Parameter 2 to plgContentPagebreak() expected to be a reference, value given in /home/ashbeeco/public_html/libraries/joomla/event/dispatcher.php on line 136

Warning: Parameter 2 to plgContentNavigation() expected to be a reference, value given in /home/ashbeeco/public_html/libraries/joomla/event/dispatcher.php on line 136

Warning: Parameter 2 to plgContentVote() expected to be a reference, value given in /home/ashbeeco/public_html/libraries/joomla/event/dispatcher.php on line 136

Warning: Parameter 2 to plgContentEmailCloak() expected to be a reference, value given in /home/ashbeeco/public_html/libraries/joomla/event/dispatcher.php on line 136

Warning: Parameter 2 to plgContentLoadModule() expected to be a reference, value given in /home/ashbeeco/public_html/libraries/joomla/event/dispatcher.php on line 136

Warning: Parameter 2 to plgContentPagebreak() expected to be a reference, value given in /home/ashbeeco/public_html/libraries/joomla/event/dispatcher.php on line 136

Warning: Parameter 2 to plgContentNavigation() expected to be a reference, value given in /home/ashbeeco/public_html/libraries/joomla/event/dispatcher.php on line 136

Warning: Parameter 2 to plgContentVote() expected to be a reference, value given in /home/ashbeeco/public_html/libraries/joomla/event/dispatcher.php on line 136

Warning: Parameter 2 to plgContentEmailCloak() expected to be a reference, value given in /home/ashbeeco/public_html/libraries/joomla/event/dispatcher.php on line 136

Warning: Parameter 2 to plgContentLoadModule() expected to be a reference, value given in /home/ashbeeco/public_html/libraries/joomla/event/dispatcher.php on line 136

Warning: Parameter 2 to plgContentPagebreak() expected to be a reference, value given in /home/ashbeeco/public_html/libraries/joomla/event/dispatcher.php on line 136

Warning: Parameter 2 to plgContentNavigation() expected to be a reference, value given in /home/ashbeeco/public_html/libraries/joomla/event/dispatcher.php on line 136

Warning: Parameter 2 to plgContentVote() expected to be a reference, value given in /home/ashbeeco/public_html/libraries/joomla/event/dispatcher.php on line 136

Warning: Parameter 2 to plgContentEmailCloak() expected to be a reference, value given in /home/ashbeeco/public_html/libraries/joomla/event/dispatcher.php on line 136

Warning: Parameter 2 to plgContentLoadModule() expected to be a reference, value given in /home/ashbeeco/public_html/libraries/joomla/event/dispatcher.php on line 136

Warning: Parameter 2 to plgContentPagebreak() expected to be a reference, value given in /home/ashbeeco/public_html/libraries/joomla/event/dispatcher.php on line 136

Warning: Parameter 2 to plgContentNavigation() expected to be a reference, value given in /home/ashbeeco/public_html/libraries/joomla/event/dispatcher.php on line 136

Warning: Parameter 2 to plgContentVote() expected to be a reference, value given in /home/ashbeeco/public_html/libraries/joomla/event/dispatcher.php on line 136

Warning: Parameter 2 to plgContentEmailCloak() expected to be a reference, value given in /home/ashbeeco/public_html/libraries/joomla/event/dispatcher.php on line 136

Warning: Parameter 2 to plgContentLoadModule() expected to be a reference, value given in /home/ashbeeco/public_html/libraries/joomla/event/dispatcher.php on line 136

Warning: Parameter 2 to plgContentPagebreak() expected to be a reference, value given in /home/ashbeeco/public_html/libraries/joomla/event/dispatcher.php on line 136

Warning: Parameter 2 to plgContentNavigation() expected to be a reference, value given in /home/ashbeeco/public_html/libraries/joomla/event/dispatcher.php on line 136

Warning: Parameter 2 to plgContentVote() expected to be a reference, value given in /home/ashbeeco/public_html/libraries/joomla/event/dispatcher.php on line 136

Excel 2007 VBA Introduction Course Contents

Hover over the content header to see more details

Click to view Course Contents as PDF file

Introduction to Macros

Record, run and delete macros
Absolute and Relative recording
Range names and macros
Run macros from Quick Access Toolbar
Run macros from spreadsheet buttons
Macro security

The Visual Basic Editor

Add the Developer ribbon tab
Visual Basic Editor components
Visual Basic Editor options

Viewing and Editing Macros

Subroutines
Editing and printing macros
Macro comments and documentation
Changing properties
Eliminating unnecessary recorded code

Macro Techniques

Select macros
Range names
Using GoTo
Relative references in macro code
Continuation, text join and line feed characters
Printing a visual basic module

Objects, Properties and Methods

Defining and using objects, properties and methods

Variables

Rules for naming variables
Declaring variables
Variable data types
Constants

Interactive Macros

Input boxes

Message boxes

Simple Rules for Writing Macros

Summary Guide to Useful Objects, Methods and Properties