Excel® VBA Programming For Dummies®, 3rd Edition by John Walkenbach.
The book in PDF Format with title Excel® VBA Programming For Dummies®, 3rd Edition by John Walkenbach is available to download for free and Download Link is at the end of the article
Contents:
Introduction
Part I: Getting Started with Excel VBA Programming
Chapter 1: What Is VBA?
Chapter 2: Jumping Right In
Part II: How VBA Works with Excel
Chapter 3: Working in the Visual Basic Editor
Chapter 4: Introducing the Excel Object Model
Chapter 5: VBA Sub and Function Procedures
Chapter 6: Using the Excel Macro Recorder
Part III: Programming Concepts
Chapter 7: Essential VBA Language Elements
Chapter 8: Working with Range Objects
Chapter 9: Using VBA and Worksheet Functions
Chapter 10: Controlling Program Flow and Making Decisions
Chapter 11: Automatic Procedures and Events
Chapter 12: Error-Handling Techniques
Chapter 13: Bug Extermination Techniques
Chapter 14: VBA Programming Examples
Part IV: Communicating with Your Users
Chapter 15: Simple Dialog Boxes
Chapter 16: UserForm Basics
Chapter 17: Using UserForm Controls
Chapter 18: UserForm Techniques and Tricks
Chapter 19: Accessing Your Macros through the User Interface
Part V: Putting It All Together
Chapter 20: Creating Worksheet Functions — and Living to Tell about It
Chapter 21: Creating Excel Add-Ins
Part VI: The Part of Tens
Chapter 22: Ten VBA Questions (and Answers)
Chapter 23: (Almost) Ten Excel Resources
Chapter 24: Ten VBA Do’s and Don’ts
Index
Is This the Right Book?
Go to any large bookstore (in-person or online), and you’ll find many Excel books (far too many, as far as I’m concerned). A quick overview can help you decide whether this book is really right for you.
This book
✓ Is designed for intermediate to advanced Excel users who want to get up to speed with Visual Basic for Applications (VBA) programming.
✓ Requires no previous programming experience.
✓ Covers the most commonly used commands.
✓ Is appropriate for Excel 2010 or Excel 2013.
✓ Just might make you crack a smile occasionally — it even has cartoons.
If you’re using Excel 2000, XP, or 2003, this book is not for you. If you’re using Excel 2007, it might be okay, but some things have changed. You’d probably be better off with the previous edition.
Oh yeah, this is not an introductory Excel book. If you’re looking for a general-purpose Excel book, check out any of the following books, which are all published by Wiley:
✓ Excel 2013 For Dummies, by Greg Harvey
✓ Excel 2013 Bible, by John Walkenbach (yep, that’s me)
Excel VBA Programming For Dummies, 3rd Edition
These books are also available in editions for earlier versions of Excel. Notice that the title of this book isn’t The Complete Guide to Excel VBA Programming For Dummies. I don’t cover all aspects of Excel programming — but then again, you probably don’t want to know everything about this topic. If you consume this book and find that you’re hungry for a more comprehensive Excel programming book, you might try Microsoft Excel 2013 Power Programming with VBA, by John Walkenbach, also published by Wiley. And, yes, editions for older versions of Excel are also available.
So You Want to Be a Programmer. . . .
Besides earning money to pay my bills, my main goal in writing this book is to show Excel users how to use the VBA language — a tool that helps you significantly enhance the power of the world’s most popular spreadsheet. Using VBA, however, involves programming. (Yikes! The p word.) If you’re like most computer users, the word programmer conjures up an image of someone who looks and behaves nothing like you. Perhaps words such as nerd, geek, and dweeb come to mind.
Times have changed. Computer programming has become much easier, and even so-called normal people now engage in this activity — and even admit it to friends and family. Programming simply means developing instructions that the computer automatically carries out. Excel programming refers to the fact that you can instruct Excel to automatically do things that you normally do manually — saving you lots of time and (you hope) reducing errors. I could go on, but I need to save some good stuff for Chapter 1.
If you’ve read this far, it’s a safe bet that you need to become an Excel programmer. This could be something you came up with yourself or (more likely) something your boss decided. In this book, I tell you enough about Excel programming so that you won’t feel like an idiot the next time you’re trapped in a conference room with a group of Excel aficionados. And by the time you finish this book, you can honestly say, “Yeah, I do some Excel programming.”
How This Book Is Organized
I divided this book into six major parts, each of which contains several chapters. Although I arranged the chapters in a fairly logical sequence, you can read them in any order you choose. Here’s a quick preview of what’s in store for you.
Part I: Getting Started with Excel VBA Programming
Part I has but two chapters. I introduce the VBA language in the first chapter.
In Chapter 2, I let you get your feet wet right away by taking you on a handson guided tour.
Part II: How VBA Works with Excel
In writing this book, I assume that you already know how to use Excel. The four chapters in Part II give you a better grasp on how VBA is implemented in Excel. These chapters are all important, so I don’t recommend skipping them, okay?
Part III: Programming Concepts
The eight chapters in Part III get you into the nitty-gritty of what programming is all about. You may not need to know all this stuff, but you’ll be glad it’s there if you ever do need it.
Part IV: Communicating with Your Users
One of the coolest parts of programming in Excel is designing custom dialog boxes (well, at least I like it). The five chapters in Part IV show you how to create dialog boxes that look like they came straight from the software lab at Microsoft.
Part V: Putting It All Together
The two chapters in Part V pull together information from the preceding chapters. You discover how to include your own custom buttons in the Excel user interface, and you find out how to develop custom worksheet functions, create add-ins, design user-oriented applications, and even work with other Office applications.
Part VI: The Part of Tens
Traditionally, books in the For Dummies series contain a final part that consists of short chapters with helpful or informative lists. Because I’m a sucker for tradition, this book has three such chapters that you can peruse at your convenience.
Now….
Reading this introduction was your first step. Now, it’s time to move on and become a programmer (there’s that p word again!).
If you’re a programming virgin, I strongly suggest that you start with Chapter 1 and progress through the book until you’ve discovered enough to do what you want to do. Chapter 2 gives you some immediate hands-on experience, so you have the illusion that you’re making quick progress.
About the Author:
John Walkenbach is the best-selling author of more than 50 spreadsheet books and lives in southern Arizona. When he’s not using Excel, he’s probably playing clawhammer banjo.
Excel® VBA Programming For Dummies®, 3rd Edition by John Walkenbach pdf.
Book Details:
⏩Author: John Walkenbach
⏩Copyright © 2013 by John Wiley & Sons, Inc
⏩Language: English
⏩Pages: 411
⏩Size: 32.7 MB
⏩Format: PDF
Disclaimer:
engreferencebooks.com website respects the intellectual property rights of others and expects its users to do the same, The book name and content is copyrighted material by the respective publishers and we are not publishing either or distributing the book. We here at Engineering Reference Pdf; neither upload books and not share it for commercial purpose. Only downloading links are shared which are found by detailed scrutiny and research over the internet. So we are here just sharing those links not the books. If you notice any copyright material please contact us immediately at DMCA form and point out its URL, we’ll remove relevant links or contents!
👇👇Downloading The Book👇👇
Download Excel® VBA Programming For Dummies®, 3rd Edition by John Walkenbach in pdf format for free.
