Excel VBA Programming For Dummies

Dick Kusleika, Dick Kusleika

$69.95

Paperback

Not in-store but you can order this
How long will it take?

Availability Information

We source books from suppliers in Australia and overseas. For books we don't currently have in stock, the time it takes to get them from our suppliers can vary widely - from a few days to a few months - so we check each book with each supplier to determine the expected time it will take to be supplied to us.

We then advise you accordingly. If the time taken to get any book is too long for you, you can let us know and we will cancel or adjust your order, and refund as required.

To find out the anticipated arrival time for specific items prior to ordering, please contact us by phone or email:

Phone +61 2 9264 3111, or 1800 4 BOOKS (1800 4 26657) if outside Sydney:
option 1 Abbey's Bookshop (Crime, History, Science, Kids & more) • info@abbeys.com.au
option 2 Language Book Centre (ESL & Foreign Languages) • language@abbeys.com.au
option 3 Galaxy Bookshop (Sci-fi, Fantasy, Romance, Graphic Novels) • sf@galaxybooks.com.au

QTY:

English

For Dummies
14 January 2022

Business applications

Find out what Excel is capable of with this step-by-step guide to VBA Short of changing the tires on your car, Microsoft Excel can do pretty much anything. And the possibilities are even more endless when you learn to program with Excel Visual Basic for Applications (VBA). Regardless of your familiarity with Excel VBA, Excel VBA Programming For Dummies can enhance your experience with the popular spreadsheet software.

Pretty soon, you'll be doing things you didn't think were possible in Excel, from automating processes to writing your own worksheet functions. You'll learn how to:

Understand the basic tools and operations of Visual Basic for Applications Create custom spreadsheet functions that make life easier for you and the people maintaining your spreadsheets Deal with errors and exceptions and eliminate the bugs in your code

Perfect for anyone who's never even heard of Excel VBA, Excel VBA Programming For Dummies is also a fantastic resource for intermediate and advanced Excel users looking for a heads-up on the latest features and newest functionality of this simple yet powerful scripting language.

By: Dick Kusleika, Dick Kusleika
Imprint: For Dummies
Country of Publication: United States
Edition: 6th edition
Dimensions: Height: 234mm, Width: 185mm, Spine: 28mm
Weight: 567g
ISBN: 9781119843078
ISBN 10: 1119843073
Pages: 432
Publication Date: 14 January 2022
Audience: Professional and scholarly , Undergraduate
Replaced By: 9781394292394
Format: Paperback
Publisher's Status: Active

Introduction 1 Part 1: Starting Excel VBA Programming 7 Chapter 1: Getting to Know VBA 9 Chapter 2: Building Simple Macros 17 Part 2: Employing 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 67 Chapter 6: Using the Excel Macro Recorder 83 Part 3: Programming Concepts 97 Chapter 7: Essential VBA Language Elements 99 Chapter 8: Working with Range Objects 119 Chapter 9: Using VBA and Worksheet Functions 135 Chapter 10: Controlling Program Flow and Making Decisions 151 Chapter 11: Automatic Procedures and Events 171 Chapter 12: Error-Handling Techniques 193 Chapter 13: Bug Extermination Techniques 205 Chapter 14: VBA Programming Examples 219 Part 4: Communicating with Your Users 243 Chapter 15: Simple Dialog Boxes 245 Chapter 16: UserForm Basics 263 Chapter 17: Using UserForm Controls 281 Chapter 18: UserForm Techniques and Tricks 301 Chapter 19: Accessing Your Macros through the User Interface 329 Part 5: Putting It All Together 343 Chapter 20: Creating Worksheet Functions 345 Chapter 21: Creating Excel Add-Ins 365 Part 6: The Part of Tens 377 Chapter 22: Ten Handy Visual Basic Editor Tips 379 Chapter 23: Resources for VBA Help 389 Chapter 24: Ten VBA Do’s and Don’ts 395 Index 401

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

WIN $150 GIFT VOUCHERS: ALADDIN'S GOLD

Excel VBA Programming For Dummies

Dick Kusleika, Dick Kusleika

$69.95

Paperback

See Also

Contact Abbeys

Contact Galaxy

Contact Language

Contact Us

About ABBEY'S