Absolute Beginner's Guide to VBA [NOOK Book]

Overview

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...

See more details below
Absolute Beginner's Guide to VBA

Available on NOOK devices and apps  
  • NOOK Devices
  • NOOK HD/HD+ Tablet
  • NOOK
  • NOOK Color
  • NOOK Tablet
  • Tablet/Phone
  • NOOK for Windows 8 Tablet
  • NOOK for iOS
  • NOOK for Android
  • NOOK Kids for iPad
  • PC/Mac
  • NOOK for Windows 8
  • NOOK for PC
  • NOOK for Mac
  • NOOK Study

Want a NOOK? Explore Now

NOOK Book (eBook)
$11.49
BN.com price
(Save 42%)$19.99 List Price

Overview

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.

Read More Show Less

Product Details

  • ISBN-13: 9780131389984
  • Publisher: Pearson Education
  • Publication date: 3/23/2004
  • Series: Absolute Beginner's Guide
  • Sold by: Barnes & Noble
  • Format: eBook
  • Edition number: 1
  • Pages: 384
  • Sales rank: 724,182
  • File size: 15 MB
  • Note: This product may take a few minutes to download.

Meet 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.

Read More Show Less

Table of Contents



Introduction.

I. GETTING STARTED WITH VBA.

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.

II. PUTTING VBA TO WORK.

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.

III. GETTING THE MOST OUT OF VBA.

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.

IV. APPENDIXES.

Appendix A. VBA Statements.
Appendix B. VBA Functions.

Read More Show Less

Customer Reviews

Average Rating 3
( 3 )
Rating Distribution

5 Star

(0)

4 Star

(1)

3 Star

(1)

2 Star

(1)

1 Star

(0)

Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

 
Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously
Sort by: Showing all of 3 Customer Reviews
  • Posted April 16, 2009

    more from this reviewer

    Useful for Getting Started

    I really had very little idea of where to even start with VBA when I got this book. I thought it did a great job for the target audience. I assume that is an Absolute Beginner. It really helped me set up and understand the code. I use Google to find actual code, but I still reference this book for definitions and naming conventions.

    Is it going to make you an expert? No, but there's so much you can do in VBA, I didn't expect it to teach me everything. I managed to put together some fairly substantial programming (if not difficult) looking at stochastic investment returns over 1000 100 year periods using the information contained within.

    Was this review helpful? Yes  No   Report this review
  • Anonymous

    Posted December 27, 2006

    Little information about practical applications.

    The book contains sample code for projects that have little practical value and does not go into enough detail to teach anyone how to write useful code. Fortunately I was able to find everything I needed, for free, on several VBA websites. I could have made much better use of the $18.95. This book isn't intelligent enough to be part of the 'Dummies' series.

    Was this review helpful? Yes  No   Report this review
  • Anonymous

    Posted January 6, 2010

    No text was provided for this review.

Sort by: Showing all of 3 Customer Reviews

If you find inappropriate content, please report it to Barnes & Noble
Why is this product inappropriate?
Comments (optional)