The +Plus Series Visual Basic for Applications

by Rea, Alan I.

• ISBN13: 9780072836165
• ISBN10: 0072836164
• Edition: 1st
• Format: Paperback
• Copyright: 2004-07-29
• Publisher: Career Education

Summary

Thousands of learners have asked for high quality materials that focus on technologies that go beyond core applications of Microsoft Office. McGraw-Hill Technology Education has answered these requests with 4 new titles making up the +Plus Series. This books were designed to stand alone as primary texts or to supplement instruction in core courses. The +Plus Series books are brief, easy to use, and less expensive than primary textbooks.

Table of Contents

VBA and You: How Can You Get the Most Out of Microsoft Office?	1	(1)
Chapter Case
Daggitt Development	2	(1)
Session 1.1
Introduction to VBA Programming	3	(1)
Where Did VBA Come From?	3	(2)
The Birth of VBA	5	(1)
General Programming Concepts	5	(2)
VBA's Role in Microsoft Office	7	(1)
Session 1.2
Using the VBA Integrated Development Environment (IDE)	8	(1)
Securing Microsoft Office	8	(2)
Opening the VBA IDE	10	(1)
Touring the VBA IDE	11	(1)
Project Explorer	12	(2)
Properties Window	14	(3)
Code Window	17	(1)
Customizing the VBA IDE Windows	18	(2)
Exploring the Excel VBA IDE	20	(1)
Comparing VBA IDEs	21	(2)
Session 1.3
Recording and Manipulating Macros	23	(1)
Recording Macros	23	(1)
Recording the Macro	24	(2)
Running a VBA Macro	26	(2)
Manipulating Macros	28	(1)
Changing the Code	29	(2)
Assigning Macros	31	(2)
Printing Macros	33	(2)
Session 1.4
Summary	35	(2)
Level One: Task Reference Roundup	37	(1)
Level Two: Review of Concepts	38	(1)
Level Three: Hands-On Projects	39	(1)
Practice	39	(2)
Challenge!	41	(2)
Running Project	43
Objects, Variables, and Functions: How Do You Access and Use Information in VBA?	1	(1)
Chapter Case
North Avenue Racquetball Foundation	2	(3)
Session 2.1
Understanding and Implementing Objects	5	(1)
Understanding the Object Model	5	(5)
Using the Object Browser	10	(3)
Understanding Objects	13	(1)
Accessing and Using Objects	14	(5)
Session 2.2
Understanding Variables	19	(1)
Storing Data	19	(1)
Creating Variables	19	(2)
Assigning Data Types	21	(2)
Naming Variables	23	(1)
Managing Variables	23	(3)
Using an Object Variable	26	(3)
Session 2.3
Using Variables and Functions	29	(1)
Using String Variables	29	(2)
Using the InputBox Function	31	(3)
Using Date and Time Variables	34	(3)
Using Number Variables	37	(5)
Session 2.4
Summary	42	(1)
Level One: Task Reference Roundup	43	(1)
Level Two: Review of Concepts	44	(1)
Level Three: Hands-On Projects	45	(1)
Practice	45	(3)
Challenge!	48	(2)
Running Project	50
Control Structures: How Can You Make Decisions in VBA?	1	(1)
Chapter Case
TRI-CEC Ticket Reservation System (Tricectrs)	2	(3)
Session 3.1
Control Structure Overview	5	(1)
Sequence Control Structure	5	(1)
Selection Control Structure	5	(2)
Repetition Control Structure	7	(1)
Session 3.2
If Then Else Statements	8	(1)
Comparison Operators	9	(1)
Logical Operators	10	(1)
Implementing the If Then Else Statement	10	(7)
Defensive Programming	17	(3)
Implementing Nested If Then Else Statements	20	(1)
Implementing the MsgBox Function	21	(5)
Session 3.3
Select Case Statements	26	(1)
Select Case Syntax	26	(1)
Implementing Select Case	27	(3)
Session 3.4
Iterations and Loops	30	(1)
Do Loops	30	(1)
Implementing a Do Loop	30	(4)
For Next Loops	34	(4)
Debugging Code during Run Time	38	(3)
Session 3.5
Summary	41	(2)
Level One: Task Reference Roundup	43	(1)
Level Two: Review of Concepts	44	(1)
Level Three: Hands-On Projects	45	(1)
Practice	45	(5)
Challenge!	50	(2)
Running Project	52
Application Development: How Can You Create Your Own Microsoft Office Application?	1	(1)
Chapter Case
Newton Sales International	2	(3)
Session 4.1
Communicating With Users	5	(1)
Dialogs Collection	5	(4)
Microsoft Office Assistant	9	(8)
Session 4.2
Customizing Your Application	17	(1)
Creating a Customized Dialog Box with Forms	17	(9)
Customizing the Newton Sales Letter Dialog Box	26	(11)
Session 4.3
Integrating Office Applications	37	(1)
Introducing the Basic Automatic Steps	37	(6)
Creating the Newton Sales Integrated Application	43	(11)
Debugging and Error Trapping	54	(3)
Session 4.4
Summary	57	(2)
Level One: Task Reference Roundup	59	(1)
Level Two: Review of Concepts	60	(1)
Level Three: Hands-On Projects	61	(1)
Practice	61	(5)
Challenge!	66	(2)
Running Project	68
End of Book
Index	1