Home Page Icon
Home Page
Table of Contents for
Microsoft Excel VBA and Macros (Office 2021 and Microsoft 365)
Close
Microsoft Excel VBA and Macros (Office 2021 and Microsoft 365)
by Bill Jelen, Tracy Syrstad
Microsoft Excel VBA and Macros (Office 2021 and Microsoft 365)
Cover Page
Title Page
Copyright Page
Pearson’s Commitment to Diversity, Equity, and Inclusion
Dedication
Contents at a Glance
Contents
Acknowledgments
About the Authors
Introduction
Chapter 1. Unleashing the power of Excel with VBA
Chapter 2. This sounds like BASIC, so why doesn’t it look familiar?
Chapter 3. Referring to ranges
Chapter 4. Looping and flow control
Chapter 5. R1C1-style formulas
Chapter 6. Creating and manipulating names in VBA
Chapter 7. Event programming
Chapter 8. Arrays
Chapter 9. Creating classes and collections
Chapter 10. Userforms: An introduction
Chapter 11. Data mining with Advanced Filter
Chapter 12. Using VBA to create pivot tables
Chapter 13. Excel power
Chapter 14. Sample user-defined functions
Chapter 15. Creating charts
Chapter 16. Data visualizations and conditional formatting
Chapter 17. Dashboarding with sparklines in Excel
Chapter 18. Reading from the web using M and VBA
Chapter 19. Text file processing
Chapter 20. Automating Word
Chapter 21. Using Access as a back end to enhance multiuser access to data
Chapter 22. Advanced userform techniques
Chapter 23. The Windows Application Programming Interface (API)
Chapter 24. Handling errors
Chapter 25. Customizing the ribbon to run macros
Chapter 26. Creating Excel add-ins
Chapter 27. An introduction to creating Office add-ins
Chapter 28. What’s new in Excel 365 and what’s changed
Index
Code Snippets
Search in book...
Toggle Font Controls
Playlists
Add To
Create new playlist
Name your new playlist
Playlist description (optional)
Cancel
Create playlist
Sign In
Email address
Password
Forgot Password?
Create account
Login
or
Continue with Facebook
Continue with Google
Sign Up
Full Name
Email address
Confirm Email Address
Password
Login
Create account
or
Continue with Facebook
Continue with Google
Prev
Previous Chapter
Code Snippets
Next
Next Chapter
Microsoft Excel VBA and Macros (Office 2021 and Microsoft 365)
Add Highlight
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click
here
login for view all page.
Day Mode
Cloud Mode
Night Mode
Reset