Overview

Full Product Details

Author:   Dick Kusleika (Daily Dose, LLC) ,  Peter Weverka
Publisher:   John Wiley & Sons Inc
Imprint:   For Dummies
Edition:   7th edition
Dimensions:   Width: 18.50cm , Height: 3.10cm , Length: 23.10cm
Weight:   0.590kg
ISBN:  

9781394292394

ISBN 10:   1394292392
Pages:   448
Publication Date:   13 February 2025
Audience:   General/trade ,  General
Format:   Paperback
Publisher's Status:   Active
Availability:   Available To Order  
We have confirmation that this item is in stock with the supplier. It will be ordered in for you and dispatched immediately.

Table of Contents

Introduction 1 Part 1: Starting Excel VBA Programming 7 Chapter 1: Getting to Know VBA 9 Chapter 2: Building Simple Macros 17 Part 2: Using VBA with Excel 29 Chapter 3: Working in the Visual Basic Editor 31 Chapter 4: Introducing the Excel Object Model 51 Chapter 5: VBA Sub and Function Procedures 65 Part 3: Creating Code Automatically 81 Chapter 6: Using the Excel Macro Recorder 83 Chapter 7: Generating Code with Copilot 95 Part 4: Programming Concepts 107 Chapter 8: Essential VBA Language Elements 109 Chapter 9: Working with Range Objects 131 Chapter 10: Using VBA and Worksheet Functions 147 Chapter 11: Controlling Program Flow and Making Decisions 163 Chapter 12: Automatic Procedures and Events 183 Chapter 13: Error-Handling Techniques 205 Chapter 14: Bug Extermination Techniques 217 Chapter 15: VBA Programming Examples 231 Part 5: Communicating with Your Users 255 Chapter 16: Simple Dialog Boxes 257 Chapter 17: UserForm Basics 275 Chapter 18: Using UserForm Controls 293 Chapter 19: UserForm Techniques and Tricks 313 Chapter 20: Accessing Your Macros through the User Interface 341 Part 6: Putting It All Together 355 Chapter 21: Creating Worksheet Functions 357 Chapter 22: Creating Excel Add-Ins 379 Part 7: The Part of Tens 391 Chapter 23: Ten Handy Visual Basic Editor Tips 393 Chapter 24: Resources for VBA Help 403 Chapter 25: Ten VBA Do’s and Don’ts 409 Index 415

Reviews

Author Information

Dick Kusleika has more than 25 years’ experience helping Office users get the most out of Microsoft’s bestselling software. From online forums to blogs, books, and con­fer­ences, he delivers sound and straightforward advice to readers of all skill levels.

Tab Content 6

Author Website:  

Countries Available

All regions