Exploring VBA for Microsoft Office 2016 Brief, 1st edition
- Mary Anne Poatsy
- , Robert T. Grauer
- , Jason Davidson
Learn more, spend less
- Study simpler and faster
Use flashcards and other study tools in your eTextbook
- Watch and learn
Videos & animations bring concepts to life
- Find it fast
Quickly navigate your eTextbook with search
- Stay organized
Access all your eTextbooks in one place
- Easily continue access
Keep learning with auto-renew
Getting Started with VBA
Objectives
Case Study: Acme Consulting
Introduction to VBA
Using VBA and Getting Help
Identifying Code in the Code Window
Creating, Running, and Debugging Procedures
Creating a Message Box
Variables, Constants, Inputs, and Outputs
Declaring and Using Variables and Constants
Referencing Values and Arrays
Creating an Input Box
Performing Calculations
Decision Structures
Using Decision Structures
Performing Data Validation
Using Logical Operators
Repetition Structures
Using the For…Next Structure
Using the Do…Loop Structure
Excel and VBA
Objectives
Case Study: Expert Financial Services
Forms and Controls
Creating Forms
Adding Controls to Forms
Adjusting Specialized Properties
Inserting Controls on a Worksheet
Procedures and Functions for Form Controls
Adding a Procedure to a Control
Creating and Calling a Function Procedure
Loan Payment Schedule and Disclosure Worksheets
Creating a List in a Worksheet
Preparing an Application for Distribution
Access and VBA
Objectives
Case Study: Garten Sporting Goods
VBA in Access
Writing Code in Modules
Writing Code in Forms and Reports
Working with Objects
Creating Functions
Working with Recordsets
Using DAQ to Access Data
Forms, Reports, and Errors in VBA
Using VBA to Add Events to Forms
Chapter Objectives Review
Key Terms Matching
Multiple Choice
Practice Exercises
Mid-Level Exercises
Beyond the Classroom
Capstone Exercise
Your questions answered
Pearson+ is a one-stop shop for eTextbooks and Study & Exam Prep (also referred to as Channels), both designed to help students get better grades in college. eTextbooks and Study & Exam Prep can be purchased separately or together. eTextbooks have built-in tools that simplify studying, like flashcards, audiobook and search. Study & Exam Prep includes video lessons, practice problems, study guides, Q&A with experts and more, to help you understand tricky topics and get you prepared for test time — all in one place.
A Pearson eTextbook is an easy-to-use digital version of your assigned textbook. eTextbooks, available in Pearson+, give you access to upgraded study tools, including enhanced search, highlights and notes, customizable flashcards, and audio options for hand-free studying. Plus, you can learn on the go with the Pearson+ app.
Pearson+ offers an eTextbook rental, billed as a 6-month subscription. A subscription includes instant access to your eTextbook, including study tools such as the ability to create custom flash cards, take notes, and the option to search and highlight important info in your eTextbook. You can also bundle your eTextbook with Study & Exam Prep. When you check out, you can make a one-time, up-front payment for your eTextbook, or you can choose to pay monthly. If you opt for monthly payments, we will charge your payment method each month until your 6-month subscription ends. If something happens and you need your eTextbook for longer than 6 months, select Extend subscription on the Manage subscription page in My account at any time to continue your subscription before it ends.
A Study & Exam Prep subscription includes video lessons, practice problems and other study tools. With a subscription, you'll get unlimited access to the full range of subjects:
When you purchase an eTextbook subscription, it will last 6 months. You can renew your subscription by selecting Extend subscription on the Manage subscription page in My account before your initial term ends. If you extend your subscription, we'll automatically charge you every month. If you made a one-time payment for your initial 6-month term, you'll now pay monthly. To make sure your learning is uninterrupted, please check your card details. To avoid the next payment charge, select Cancel subscription on the Manage subscription page in My account before the renewal date. You can subscribe again in the future by purchasing another eTextbook subscription.
Channels, also referred to as Study & Exam Prep, is a video platform with thousands of explanations, solutions, and practice problems in 19 subjects to help you do homework and prep for exams. Videos are personalized to your course, and tutors walk you through solutions. Plus, interactive AI-powered summaries and a social community help you understand lessons from your class.
Channels doesn't replace traditional textbooks or eTextbooks. It's an additional tool to help you with your studies, and it can be used with Pearson textbooks or non-Pearson textbooks.
When you choose a Channels subscription, you're signing up for a 1-month, 3-month or 12-month term and you make an upfront payment for your subscription. By default, these subscriptions auto-renew at the frequency you select during checkout. You'll have access to the full video library across all 19 subjects once you've subscribed. You can bundle Channels (also referred to as Study & Exam Prep) with your eTextbook at the time of purchase. Bundle subscription terms vary. You can choose your subscription term and payment frequency at checkout.
When you purchase a Channels subscription, it will last 1 month, 3 months or 12 months, depending on the plan you chose. Your subscription will automatically renew at the end of your term unless you cancel it. We use your credit card to renew your subscription automatically. To make sure your learning is uninterrupted, please check your card details. If your payment method fails, we'll send you an email with instructions for how to update it.