Excel VBA programming
"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…
Read More ↓Title Statements
- Full title :Excel VBA programming / by Dick Kusleika.
Summary
"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.
Read More ↓Edition Statements
- Publication Date:©2022
- Edition:6th edition
Publication Statements
- Publisher(s):John Wiley & Sons, Inc
- Place of Publication:Hoboken, NJ
- Language:eng
- Publication Date:©2022
Notes
Comprend un index.
The Physical Object
- Description:xiv, 416 pages : : illustrations ; : 24 cm
Edition Identifiers
- ISBN:1119843073, 9781119843078
- oclc:on1304314294
- Dewey Decimal:005.54
Table of 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.
Read More ↓Subjects
Writers
More from this Series
No reviews yet. Be the first to rate this work.
Related Works
more →
Excel for engineers and scientists
Dynamic models in chemistry: a workbook of computer simulations usin…
Atkinson, Daniel E.
Dynamic models in chemistry: a workbook of computer simulations usin…
Atkinson, Daniel E.
Rate & Review