Skip to content

VBA for Dummies

Spend $50 to get a free DVD!

ISBN-10: 076450567X

ISBN-13: 9780764505676

Edition: 2nd 1999

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:

Readers who want to customise Office 2000, Corel WordPerfect Suite, AutoCad or any hundreds of other VBA-ready applications will find the step-by-step instructions to accomplish their goals.
Customers also bought

Book details

List price: $24.99
Edition: 2nd
Copyright year: 1999
Publisher: John Wiley & Sons, Incorporated
Publication date: 8/25/1999
Binding: Paperback
Pages: 448
Size: 7.40" wide x 9.25" long x 1.10" tall
Weight: 1.804
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
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
Returning to Your VBA Application
Running VBA Programs
The Name Is Everything
Running from the Macro Dialog Box
Launching Programs Quickly
Running VBA Programs Automatically
Mastering the VBA Development Environment
The Visual Basic Editor at Your Command
Working with the Visual Basic Editor User Interface
Managing the Windows
Getting Things Done in the Visual Basic Editor
Managing Your Projects with Project Explorer
Using the Object Browser
Coding Secrets
Using the Properties Window
A First Look at the Debugging Windows
The Main Course in VBA Programming
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
Manners, Please! VBA Etiquette
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
Objectivity
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
Events
Identifying the Object You Want to Work With
Efficient Object Coding
The Instruments in VBA's Built-In Orchestra
Finding Built-In Commands
Formatting Data
Converting Data
Con Text
Working with Dates and Times
Simple Interactions with the World
Working with Boolean values
Fun with Math and Money
Miscellaneous Built-In Commands
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
Advanced Data Storage: Arrays and Collections
Seeing A-rray of Hope
Managing Sets of Data with Collection Objects
Defining Your Own Data Types
Unbreakable Code: Debugging and Error Trapping
What Can Go Wrong Does Go Wrong
Fixing Syntax Errors
Entomology for VBA Programmers
Seeing Data Tips
Immediate Gratifications
Keeping an Eye on the Locals (Window)
The Watch Window: Key Debugging Tool
Trapping Wild Bugs with On Error and the Error Object
Designing Active Forms
Laying Out VBA Forms
Getting Started with Form Design
Laying Out a New Form
Working with Form and Control Properties
Working with Key Form and Control Properties
Editing Controls: The Basics
Formatting Controls
Form Programming
If You've Got It, Flaunt It!
Loading and Showing Forms
The Main Events
Event Procedures Gotta Have Code
Handling Common Form Programming Tasks
Validating Entries
The Part of Tens
Ten (Minus Three) Really Cool Things You Can Do with VBA
Storing Stuff in the Windows Registry
Exposing Themselves (Accessing the Objects of Other Applications)
Managing Database Data with VBA
Working with Disk Files
Using Dictionary Objects
Do-It-Yourself Objects
Adding ActiveX Controls
Ten (Times Three) VBA Resources
Your First Stop for More VBA Info
Magazines and Newsletters
Public VBA Web Sites
A Galaxy of ActiveX Controls
Miscellaneous Stuff
About the CD
System Requirements
How to Use the CD
What You'll Find
VBA For Dummies source code
iGrafx Professional from Micrografx
ActiveX Component Suite from ProtoView Development Corp
ActiveCandy by Edward Blake
DameWare ActiveX controls from DameWare Development
FSCompressFile by Fulvio Senore
CodeSmith from Berkeley Software Associates
SpeedFerret for Access 97 from Black Moshannon Systems
EasyHelp/Web and EasyHTML/Help from Eon Solutions, Ltd.
ClipMate from ThornSoft Development
Desktop.VBA from ASM, Inc.
WinZip 7.0 from Nico Mak Computing, Inc.
Time To Win
Sax Basic (Sax Software Corporation)
If You Have Problems (Of the CD Kind)
Index
IDG Books Worldwide End-User License Agreement
Installation Instructions
Book Registration Information