Title:
Excel VBA programming
Author:
Edition:
6th edition.
Publication Date:
2022
Publication Information:
Hoboken, NJ : John Wiley & Sons, Inc, [2022]
©2022
Physical Description:
xiv, 416 pages : illustrations ; 24 cm
ISBN:
9781119843078
Abstract:
"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"--Publisher's description.
General Note:
Includes index.
John Walkenbach listed as primary author in earlier editions.
Contents:
Starting Excel VBA programming. Getting to know VBA ; Building simple macros -- Employing VBA with Excel. Working in the Visual Basic Editor ; Introducing the Excel object model ; VBA sub and function procedures ; Using the Excel macro recorder -- Programming concepts. Essential VBA language elements ; Working with range objects ; Using VBA and worksheet functions ; Controlling program flow and making decisions ; Automatic procedures and events ; Error-handling techniques ; Bug extermination techniques ; VBA programming examples -- Communicating with your users. Simple dialog boxes ; UserForm basics ; Using UserForm controls ; UserForm techniques and tricks ; Accessing your macros through the user interface -- Putting it all together. Creating worksheet functions ; Creating Excel add-ins -- The part of tens. Ten handy Visual Basic Editor tips ; Resurces for VBA help ; Ten VBA do's and don'ts.
Title Subject:
Language:
English
