The Super Fun Kids' Graphic Novel Sale

Special Offers see all

Enter to WIN a $100 Credit

Subscribe to
for a chance to win.
Privacy Policy

Visit our stores

    Recently Viewed clear list

    Original Essays | September 23, 2015

    Bryan Doerries: IMG Using Greek Tragedies to Comfort the Afflicted and Afflict the Comfortable

    In ancient Athens, during the fifth century BC, military service was required of all citizens. To be a citizen meant being a soldier, and vice... Continue »
    1. $18.87 Sale Hardcover add to wish list

Qualifying orders ship free.
List price: $24.95
Used Trade Paper
Ships in 1 to 3 days
Add to Wishlist
Qty Store Section
1 Burnside Computer Languages- Visual Basic

More copies of this ISBN

Absolute Beginner's Guide to VBA (Absolute Beginner's Guides)


Absolute Beginner's Guide to VBA (Absolute Beginner's Guides) Cover


Synopses & Reviews

Publisher Comments:

Visual Basic for Applications (VBA) is a set of tools based on the Visual Basic language. The great thing about using it to enhance Office applications is that it's easier to learn than Visual Basic and it comes with your Office license. After reading this book, the reader will be proficient in the VBA language and will have extensive knowledge of the Office 2003 Object Model. This book will cover all features of the VBA editor and show how to program some of the more useful new features in the Office 2003 applications.

This book assumes no prior programming experience, so even programming novices can get up to speed quickly on the basics of the VBA language. It is very practical and offers the reader tested programs and projects that he or she can implement right away. This book reinforces the reader's learning by presenting useful, end-of-chapter pedagogical resources, including question-and-answer sessions and quizzes, as well as practical exercises that cement and extend the reader's knowledge. It explorers not only the object models of Word and Excel, but also other members of the Office 2003 suite, including PowerPoint, Access, and Outlook.

About the Author

Paul McFedries is the president of Logophilia Limited, a technical writing company. While now primarily a writer, Paul has worked as a programmer, consultant, spreadsheet developer, and Web site developer. Paul has written more than 40 books that have sold nearly three million copies worldwide. These books include Access 2003 Forms, Reports, and Queries, Formulas and FUnctions with Microsoft Excel 2003, and The Complete Idiot's Guide to Windows XP.

Table of Contents



1. Recording Your First Macro.

What Is a Macro? Recording a VBA Macro.
2. Writing Your Own Macros.

Displaying the Visual Basic Editor. Touring the Visual Basic Editor. Writing Your Own Command Macro. Running a VBA Macro. Creating User-Defined Functions with VBA. Working with Procedures. Working with Modules. Shutting Down the Visual Basic Editor.
3. Understanding Program Variables.

Declaring Variables. Avoiding Variable Errors. Variable Data Types. Using Array Variables. Working with Constants.
4. Building VBA Expressions.

Working with VBA Operators. Understanding Operator Precedence. Working with Numeric Expressions. Working with String Expressions. Working with Logical Expressions. Working with Date Expressions.
5. Working with Objects.

The Object Hierarchy. Working with Object Properties. Working with Object Methods. Handling Object Events. Working with Object Collections. Assigning an Object to a Variable. The Is Operator. Working with Multiple Properties or Methods. Example: The Application Object. Example: The Window Object.
6. Controlling Your VBA Code.

Code That Makes Decisions. Using If...Then to Make True/False Decisions. Using If...Then...Else to Handle a False Result. Making Multiple Decisions. Functions That Make Decisions. Code That Loops. Using Do...Loop Structures. Using For...Next Loops. Using For Each...Next Loops. Using Exit For or Exit Do to Exit a Loop.


7. Programming Word.

Working with Documents. Working with Text. The Range Object. The Selection Object. The Characters Object. The Words Object. The Sentences Object. The Paragraph Object.
8. Programming Excel.

Excels Application Object. Manipulating Workbook Objects. Dealing with Worksheet Objects. Working with Range Objects.
9. Programming PowerPoint.

PowerPoints Application Object. PowerPoints Presentation Object. Working with PowerPoint Slide Objects. Dealing with Shape Objects. Operating a Slide Show.
10. Programming Access Databases.

Getting Ready: Two Steps Before You Begin. Working with Database Records: Opening a Recordset. Working with a Recordset. Retrieving Data into Excel.
11. Programming Outlook Email.

Working with Outlook Folders. Working with Email Messages. Sending a Message. Working with Attachments. Programming Outlook from Other Applications.


12. Interacting with the User.

Programming Sounds. Displaying Information to the User. Getting Input from the User.
13. Creating Custom VBA Dialog Boxes.

Adding a Form to Your Project. Changing the Forms Design-Time Properties. Working with Controls. Handling Form Events. Types of Form Controls.Using a Form in a Procedure.
14. Creating Custom Menus and Toolbars.

Assigning Macros to Menu Commands. Creating Custom Toolbars for Your Macros. Menus, Toolbars, and VBA. Understanding Command Bars. Working with Command Bar Controls.
15. Debugging VBA Procedures.

Trapping Program Errors. A Basic Strategy for Debugging. Pausing a Procedure. Stepping Through a Procedure. Monitoring Procedure Values. Using the Immediate Window. Debugging Tips.


Appendix A. VBA Statements.

Appendix B. VBA Functions.

Product Details

Mcfedries, Paul
McFedries, Paul
Programming Languages - Visual BASIC
Application software
Computer Languages-Visual Basic
Edition Description:
Trade paper
Absolute Beginner's Guide
Publication Date:
March 2004
Grade Level:
9 x 7.3 x 1 in 635 gr

Other books you might like

  1. Applied Microsoft .Net Framework... Used Trade Paper $1.98
  2. VB & VBA in a Nutshell (In a Nutshell) Used Trade Paper $6.50
  3. Beginning 2ND Edition Used Trade Paper $0.50
  4. Beginning Visual Basic 6 Objects Used Trade Paper $6.50
  5. Office VBA Macros You Can Use Today:... New Trade Paper $36.25
  6. Sams Teach Yourself Beginning... Used Trade Paper $21.00

Related Subjects

Computers and Internet » Computer Languages » The Attic
Computers and Internet » Computer Languages » Visual Basic

Absolute Beginner's Guide to VBA (Absolute Beginner's Guides) Used Trade Paper
0 stars - 0 reviews
$16.95 In Stock
Product details 384 pages Que - English 9780789730763 Reviews:
  • back to top


Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and gifts — here at