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

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 Intermediate Course Contents

Hover over the content header to see more details

Click to view Course Contents as PDF file

Conditional Statements in Macro Code

IF-THEN, IF-THEN-ELSE,
ELSEIF, SELECT CASE

Looping in Macro Code

DO WHILE LOOP, DO UNTIL LOOP,
FOR…NEXT LOOP, FOR…EACH LOOP, EXIT FOR

Error Handling in Macro Code

Enable Error Handling
ON ERROR Statements

User Forms

Create User Forms
User Form Controls
Write code to activate a form
Create a subroutine to open a form

Custom Functions

Create a custom function
Custom Functions in Excel worksheets

Debugging Macro Code

Message Boxes when Debugging Code
VBA Debug Toolbar
Compile VBA Projects

Add-Ins

Built in Add-Ins
Custom Add-Ins
Create, Modify, Load, Unload and Delete Custom Add-Ins

Optimising Macros

Display Alerts
Screen Updating

Simple Rules for Writing Macros

Summary Guide to Useful Objects, Methods and Properties