Skip to content

VBA for Dummies

ISBN-10: 0764508563

ISBN-13: 9780764508561

Edition: 3rd 2001

Authors: Steve Cummings

List price: $24.99
Blue ribbon 30 day, 100% satisfaction guarantee!
what's this?
Rush Rewards U
Members Receive:
Carrot Coin icon
XP icon
You have reached 400 XP and carrot coins. That is the daily max!

Description:

VBA for Dummies starts with a brief background on VBA and an explanation of key jargon and theoretical concepts. It then covers practical programming topics, such as VBA development environment, Visual Basic Editor, and specific tips and tricks.
Customers also bought

Book details

List price: $24.99
Edition: 3rd
Copyright year: 2001
Publisher: John Wiley & Sons, Incorporated
Publication date: 6/29/2001
Binding: Paperback
Pages: 432
Size: 7.25" wide x 9.00" long x 0.75" tall
Weight: 1.496
Language: English

Introduction
What the Book Covers
I Shouldn't Make Any Assumptions ...
Divide and Conquer
How to Use the Examples
What's on the CD-ROM
Icons Used in This Book
The VBA For Dummies Web Site(s)
VBA Boot Camp
Don't Sweat the Technical Stuff--and It's All Technical Stuff
Why Bother with VBA?
VBA Is the Steering Wheel, but You Still Need the Car
Programming with VBA
More about What You Can Do with VBA
Not Your Mama's BASIC
Don't Program When You Can Record a Macro
Understanding How Macros Work
Planning a Macro
Recording Macros
Modifying Macros--the Easy Way to Write Code
Basic VBA Programming
Starting the Visual Basic Editor
I Need Help!
Creating a VBA Program
Running a Form from Other VBA Code
Returning to Your VBA Application
Running VBA Programs
The Name Is Everything
Running from the Macros dialog box
Launching Programs Quickly
Running VBA Programs Automatically
The Visual Basic Editor at Your Command
Working with the Visual Basic Editor User Interface
Managing the Windows
Managing Your Projects with Project Explorer
Using the Object Browser
Coding Secrets
Using the Properties Window
A First Look at the Debugging Windows
VBA Programming Essentials
Anatomy of a Great VBA Program
Program Building Blocks
Where Do Projects Come from, Mommy?
Totally Modular
Writing Procedures
Scoping Out the Scope
Making Statements
Naming Your Babies
Making Your Code Pretty
Remarks About Comments
Storing and Modifying Information
Working with Variables
Working with Values Constant-ly
Hello, Operators
Details on Data Types
Controlling the Flow
Controlling Wild Programs with Control Structures
The Road Taken: Using Condition Expressions
Using if...Then Statements
Using Select Case Statements
Repeating Yourself with Loops
Interrupting the Flow with GoTo
Unbreakable Code: Debugging and Error Trapping
What Can Go Wrong Does Go Wrong
Fixing Syntax Errors
Entomology for VBA Programmers
Seeing Data Tips
Immediate Gratification
Keeping an Eye on the Locals (Window)
The Watch Window: Key Debugging Tool
Trapping Wild Bugs with On Error and the Error Object
Creating Interactive VBA Forms
Designing Forms
Controls, Behave Yourself!
Form Programming
Stretching Out
Built-in VBA Commands
Finding Built-In Commands
Formatting Data
Converting Data
Con Text
Working with Dates and Times
Simple Interactions with the World
Fun with Math and Money
Miscellaneous Built-In Commands
Object-Oriented Programming
So What's an Object?
What's an Object Model?
VBA Forms Are Objects, Too
Using Objects in Code: An Introduction
Getting and Changing Object Properties
Method Acting
Comprehending Events
Identifying the Object You Want to Work With
Efficient Object Coding
Baskets for Data Storage: Arrays and Collections
Seeing A-rray of Hope
Managing Sets of Data with Collection Objects
Defining Your Own Data Types
The Part of Tens
Ten (Minus Three) Really Cool Things You Can Do with VBA
Ten (Times Three) VBA Resources
About the CD
Bonus Part: Extras (On the CD-ROM)
VBA Programming in Office
Taking Control of Toolbars and Menus
Programming the Office Assistant
Storing Document Variables
VBA Programming in Word
Understanding the Application Object
Accessing World Documents in VBA
Opening Windows with VBA
Working with the Selection Object
Understanding Range Objects
Working with Text in Word VBA
Finding and Replacing in Word VBA
Using Document Variables
VBA Programming in Excel
Navigating the Excel Object Model
Working with Cells in Code Using Range Objects
Programming Custom Worksheet Functions
Using Built-In Functions in Your Code
Programming for Excel Events
Database Programming
Backgrounder on VBA Database Programming Technology
Database programming choices
Writing Database Code with ADO
Working with SQL
Working with Disk Files
The Number Is the Key
More on VBA Forms
More on Form and Control Appearance
More on Working with Controls
More on Form Programming
Index
Hungry Minds End-User License Agreement
Installation Instructions