VBA and Macros for Microsoft Excel

Author:: Bill Jelen; Tracy Syrstad
Format:: Softcover

Now:	R449.95
eBucks:	eB4500

United States of America

Delivery:: Usually within 16 working days.
Seller:: kalahari.com

E-mail

Email this product to a friend

Friend's email address

Your email address

Your name

Message (optional)

Cancel

Short description

This volume provides a thorough introduction to programming macros with Microsoft Excel and VBA.

Long description

There are an estimated 400 million Excel users. Many are Excel power users, but far fewer have figured out how to effectively use Excel VBA. This book is designed to get Excel users up and running with Excel VBA. Many Excel users are frustrated when they record their own macros with the macro recorder, only to discover that the macros won't work exactly right the next day. This book explains the shortcomings of the macro recorder, but also covers how to take the recorded code and turn it into something really useful. Once you are over that hurdle, the book explains how to understand the object- oriented Visual Basic for Applications Language. After those fundamentals, the book describes everything you could conceivably need to know to automate reports and design applications in Excel VBA. ~Whether you want to automate reports for your office or design full-blown applications for others, this book is for you. *Understand why the macro recorder doesn t work! *Learn how to convert recorded code into something useful *VBA syntax explained in easy-to-understand English *Automate Excel s power tools: Pivot Tables, Charts, Advanced Filters *Save hours per week by automating redundant tasks *Dramatically increase your efficiency with Excel

Product details

Publisher:: QUE
ISBN:: 9780789731296
Publication date:: May 2004
Length:: 231mm
Width:: 186mm
Thickness:: 33mm
Weight:: 953g
Pages:: 576
Illustrations:: Illustrated
Readership:: Tertiary education; Professional & scholarly
Illustrated:: Illustrated

Introduction
Getting Results with VBA
What Is in This Book
A Brief History of Spreadsheets and Macros
The Future of VBA and Excel
Special Elements and Typographical Conventions
Next Steps
I
FIRST STEPS UP THE VBA LEARNING CURVE
Unleash the Power of Excel with VBA! The Power of Excel
Barriers to Entry
Knowing Your Tools
The Visual Basic Toolbar
Macro Security
Overview of Recording, Storing, and Running a Macro
Running a Macro
Understanding the Visual Basic Editor (VBE)
Examining Code in the Programming Window
Running the Macro on Another Day Produces Undesired Results
Frustration
Next Steps
Learning VBA Is the Solution
This Sounds Like BASIC, So Why Doesn't It Look Familiar? I Can't Understand This Code
Understanding the Parts of VBA "Speech"
Is VBA Really This Hard? No! Examining Recorded Macro Code
Using the VB Editor and Help
Using Debugging Tools to Figure Out Recorded Code
The Ultimate Reference to All Objects, Methods, Properties
Five Easy Tips for Cleaning Up Recorded Code
Putting It All Together
Fixing the Recorded Code
Next Steps
Referring to Ranges
The Range Object
Using the Top
Left and Bottom
Right Corners of a Selection to Specify a Range
Referencing Ranges in Other Sheets
Referencing a Range Relative to Another Range
Using the Cells Property to Select a Range
Using the Offset Property to Refer to a Range
Using the Resize Property to Change the Size of a Range
Using the Columns and Rows Properties to Specify a Range
Using the Union Method to Join Multiple Ranges
Using the Intersect Method to Create a New Range from Overlapping Ranges
Using the IsEmpty Function to Check Whether a Cell Is Empty
Using the CurrentRegion Property to Quickly Select a Data Range
Using the Areas Collection to Return a Non
contiguous Range
Next Steps
User
Defined Functions
Creating User
Defined Functions
Useful Custom Excel Functions
Next Steps
Looping
For Next Loops
Do Loops
The VBA Loop
For Each
Next Steps
RC Style Formulas
Referring to Cells
A Versus RC References
Switching Excel to Display RC Style References
The Miracle of Excel Formulas
Explanation of RC Reference Style
Conditional Formatting
RC Required
Array Formulas Require Conditional Formatting
Next Steps
Names
Global Versus Local Names
Adding Names
Deleting Names
Types of Names
Hiding Names
Checking for the Existence of a Name
Next Steps
Event Programming
Levels of Events
Using Events
Workbook Events
Worksheet Events
Chart Sheet Events
Application
Level Events
Next Steps
UserForms
An Introduction
User Interaction Methods
Creating a Userform
Calling and Hiding a Userform
Using Basic Form Controls
Using the Multipage Control to Combine Forms
Next Steps
II
AUTOMATING EXCEL POWER IN VBA
Charts