Excel 2003: VBA Programming

by COURSE TECHNOLOGY ILT/NIIT

• ISBN13: 9780619204105
• ISBN10: 0619204109
• Edition: 1st
• Format: Paperback
• Copyright: 2004-03-30
• Publisher: Instructor Led Training

Summary

This ILT Series manual for Excel 2003: VBA Programming is designed to give proficiency to create procedures that run in response to specific events, create user forms to accept or display data, validate the data entry in user forms, and debug and handle errors in code. The manual is designed for quick scanning in the classroom and filled with interactive exercises that help ensure student success.

Table of Contents

Introduction	iii
Topic A: About the manual	iv
Topic B: Setting your expectations	vii
Topic C: Re-keying the course	x
Visual Basic Editor	1	(1)
Topic A: Visual Basic for Applications	2	(5)
Topic B: Object programming	7	(13)
Topic C: The Object Browser	20	(3)
Unit summary: Visual Basic Editor	23
Programming basics	1	(1)
Topic A: Data 2-2
Topic B: Scope of variables	13	(5)
Topic C: Scope of procedures	18	(8)
Unit summary: Programming basics	26
Control structures	1	(1)
Topic A: Decision structures	2	(10)
Topic B: Loop structures	12	(10)
Unit summary: Control structures	22
Custom dialog boxes	1	(1)
Topic A: User forms	2	(6)
Topic B: Events	8	(5)
Unit summary: Custom dialog boxes	13
Debugging and error-handling	1	(1)
Topic A: Errors	2	(2)
Topic B: Debugging	4	(14)
Topic C: Error-handling	18	(5)
Unit summary: Debugging and error-handling	23
Course summary	1	(1)
Topic A: Course summary	2	(2)
Topic B: Continued learning after class	4
Quick reference	1	(1)
Index	1