Excel 2019 Power Programming With Vba

Maximize your Excel experience with VBA
 
Excel 2019 Power Programming with VBA is fully updated to cover all the latest tools and tricks of Excel 2019. Encompassing an analysis of Excel application development and a complete introduction to Visual Basic for Applications (VBA), this comprehensive book presents all of the techniques you need to develop both large and small Excel applications. Over 800 pages of tips, tricks, and best practices shed light on key topics, such as the Excel interface, file formats, enhanced interactivity with other Office applications, and improved collaboration features.
 
Understanding how to leverage VBA to improve your Excel programming skills can enhance the quality of deliverables that you produce--and can help you take your career to the next level.
* Explore fully updated content that offers comprehensive coverage through over 900 pages of tips, tricks, and techniques
* Leverage templates and worksheets that put your new knowledge in action, and reinforce the skills introduced in the text
* Improve your capabilities regarding Excel programming with VBA, unlocking more of your potential in the office
 
Excel 2019 Power Programming with VBA is a fundamental resource for intermediate to advanced users who want to polish their skills regarding spreadsheet applications using VBA.

Inhaltsverzeichnis

Introduction xxxiii
 
Part I: Introduction to Excel VBA 1
 
Chapter 1: Essentials of Spreadsheet Application Development 3
 
What Is a Spreadsheet Application? 3
 
Steps for Application Development 4
 
Determining User Needs 5
 
Planning an Application That Meets User Needs 6
 
Determining the Most Appropriate User Interface 7
 
Concerning Yourself with the End User 12
 
Other Development Issues 17
 
Chapter 2: Introducing Visual Basic for Applications 19
 
Getting a Head Start with the Macro Recorder 19
 
Working with the Visual Basic Editor 32
 
VBA Fundamentals 43
 
Deep Dive: Working with Range Objects 48
 
Essential Concepts to Remember 52
 
Don't Panic-You Are Not Alone 54
 
Chapter 3: VBA Programming Fundamentals 61
 
VBA Language Elements: An Overview 61
 
Comments 63
 
Variables, Data Types, and Constants 65
 
Assignment Statements 76
 
Arrays 78
 
Declaring Arrays 78
 
Object Variables 80
 
User-Defined Data Types 81
 
Built-in Functions 82
 
Manipulating Objects and Collections 85
 
Controlling Code Execution 88
 
Chapter 4: Working with VBA Sub Procedures 105
 
About Procedures 105
 
Executing Sub Procedures 108
 
Passing Arguments to Procedures 119
 
Error-Handling Techniques 123
 
A Realistic Example That Uses Sub Procedures 127
 
Utility Availability 140
 
Evaluating the Project 141
 
Chapter 5: Creating Function Procedures 143
 
Sub Procedures vs. Function Procedures 143
 
Why Create Custom Functions? 144
 
An Introductory Function Example 144
 
Function Procedures 148
 
Function Arguments 153
 
Function Examples 153
 
Emulating Excel's SUM Function 167
 
Extended Date Functions 170
 
Debugging Functions 172
 
Dealing with the Insert Function Dialog Box 173
 
Using Add-Ins to Store Custom Functions 178
 
Using the Windows API 178
 
Chapter 6: Understanding Excel's Events 183
 
What You Should Know About Events 183
 
Getting Acquainted with Workbook-Level Events 189
 
Examining Worksheet Events 197
 
Monitoring with Application Events 206
 
Chapter 7: VBA Programming Examples and Techniques 217
 
Learning by Example 217
 
Working with Ranges 218
 
Working with Workbooks and Sheets 246
 
VBA Techniques 251
 
Some Useful Functions for Use in Your Code 258
 
Some Useful Worksheet Functions 263
 
Windows API Calls 278
 
Part II: Advanced VBA Techniques 287
 
Chapter 8: Working with Pivot Tables 289
 
An Introductory Pivot Table Example 289
 
Creating a More Complex Pivot Table 295
 
Creating Multiple Pivot Tables 299
 
Creating a Reverse Pivot Table 302
 
Chapter 9: Working with Charts 305
 
Getting the Inside Scoop on Charts 305
 
Creating an Embedded Chart 308
 
Creating a Chart on a Chart Sheet 309
 
Modifying Charts 309
 
Using VBA to Activate a Chart 310
 
Moving a Chart 311
 
Using VBA to Deactivate a Chart 312
 
Determining Whether a Chart Is Activated 313
 
Deleting from the ChartObjects or Charts Collection 313
 
Looping Through All Charts 314
 
Sizing and Aligning ChartObjects 317
 
Creating Lots of Charts 318
 
Exporting a Chart 321
 
Changing the Data Used in a Chart 322
 
Using VBA to Display Cust

Über den Autor / die Autorin

MICHAEL ALEXANDER is a Microsoft Certified Application Developer and author of several books on Microsoft Access and Excel. He runs a free tutorial site at datapigtechnologies.com.

DICK KUSLEIKA has been helping users get the most out of Microsoft Office products for more than twenty-five years through online forums, blogging, books, and conferences.

Zusammenfassung

Maximize your Excel experience with VBA

Excel 2019 Power Programming with VBA is fully updated to cover all the latest tools and tricks of Excel 2019. Encompassing an analysis of Excel application development and a complete introduction to Visual Basic for Applications (VBA), this comprehensive book presents all of the techniques you need to develop both large and small Excel applications. Over 800 pages of tips, tricks, and best practices shed light on key topics, such as the Excel interface, file formats, enhanced interactivity with other Office applications, and improved collaboration features.

Understanding how to leverage VBA to improve your Excel programming skills can enhance the quality of deliverables that you produce--and can help you take your career to the next level.
* Explore fully updated content that offers comprehensive coverage through over 900 pages of tips, tricks, and techniques
* Leverage templates and worksheets that put your new knowledge in action, and reinforce the skills introduced in the text
* Improve your capabilities regarding Excel programming with VBA, unlocking more of your potential in the office

Excel 2019 Power Programming with VBA is a fundamental resource for intermediate to advanced users who want to polish their skills regarding spreadsheet applications using VBA.

Produktdetails

• Autoren: Alexander, M Alexander, Michae Alexander, Michael Alexander, Michael (McKinney Alexander, Michael Kusleika Alexander, Dick Kusleika, Dick Alexander Kusleika, Richard Kusleika
• Verlag: Wiley, John and Sons Ltd
• Sprache: Englisch
• Produktform: Taschenbuch
• Erschienen: 28.02.2019
• EAN: 9781119514923
• ISBN: 978-1-119-51492-3
• Seiten: 784
• Themen: Naturwissenschaften, Medizin, Informatik, Technik > Informatik, EDV > Anwendungs-Software; Excel 2019, Office 2019, Microsoft Excel, VBA, End-User Computing, Computer-Ratgeber