Exploring VBA for Microsoft Office 2016 Brief, 1st edition
Your access includes:
- Search, highlight, notes, and more
- Easily create flashcards
- Use the app for access anywhere
- 14-day refund guarantee
$10.99per month
Minimum 4-month term, pay monthly or pay $43.96 upfront
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
Overview
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
Published by Pearson (January 1st 2021) - Copyright © 2017
ISBN-13: 9780137401963
Subject: Computer Concepts
Category: Exploring VBA for Microsoft Office 2016 Brief
Your questions answered
When you purchase an eTextbook subscription, it will last 4 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 4‑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.
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.