Microsoft Excel 2021 Programming Pocket Primer
- Length: 262 pages
- Edition: 1
- Language: English
- Publisher: Mercury Learning and Information
- Publication Date: 2022-10-24
- ISBN-10: 168392892X
- ISBN-13: 9781683928928
- Sales Rank: #0 (See Top 100 Books)
As part of the successful Pocket Primer series, this book was designed for someone like you who needs to master Excel programming fundamentals without spending too much time. All you need is a short book to get you started. It will show you only the things you need to know to feel at home with VBA. What you learn in this book on Excel programming will also apply to, say, Access programming. The book is divided into nine chapters that progressively introduce you to programming Microsoft Excel 2021.
Features:
- Includes a companion disc with all of the “Hands-On” files needed to complete the chapter projects and all the images from the text (also available from the publisher by writing to [email protected]
- Introduces you to using the VBA programming language in Microsoft Excel 2021.
Cover Page Half-Title Page License, Disclaimer Title Page Copyright Page Contents Acknowledgments Introduction Chapter 1 Excel Macros: A Quick Start in Excel VBA Programming Macros and VBA Enabling the Developer Tab in Excel Using the Built-In Macro Recorder Improving Your Recorded Macros Creating a Master Macro Various Methods of Running Macros Summary Chapter 2 Excel Programming Environment: A Quick Overview of its Tools and Features (VBE) Understanding the Project Explorer Window Understanding the Properties Window Understanding the Code Window Setting the VBE Options Syntax and Programming Assistance Using the Object Browser Using the VBA Object Library Using the Immediate Window Working with Worksheet Cells and Ranges Working with Rows and Columns Entering Data and Formatting Cells Working with Workbooks and Worksheets Working with Windows Working with the Excel Application Summary Chapter 3 Excel VBA Fundamentals: A Quick Reference to Writing VBA Code Excel Objects, Properties, and Methods Microsoft Excel Object Model Writing Simple and Complex VBA Statements Saving Results of VBA Statements Introducing Data Types Using Variables Using Constants Converting between Data Types Using Static Variables in VBA Procedures Using Object Variables in VBA Procedures Summary Chapter 4 Excel VBA Procedures: A Quick Guide to Writing Function Procedures Understanding Function Procedures Various Methods of Running Fnction Procedures Ensuring Availability of Your Custom Functions Passing Arguments to Function Procedures Testing a Function Procedure Locating Built-In Functions Getting to Know the MsgBox Function Getting to Know the InputBox Function Using the InputBox Method Summary Chapter 5 Adding Decisions to Excel VBA Programs: A Quick Introduction to Conditional Statements Relational and Logical Operators Using If...Then Statement Using If...Then...Else Statement Using If...Then...ElseIf Statement Nested If...Then Statements Using the Select Case Statement Writing a VBA Procedure with Multiple Conditions Using Conditional Logic in Function Procedures Summary Chapter 6 Adding Repeating Actions to Excel VBA Programs: A Quick Introduction to Looping Statements Introducing Looping Statements Understanding Do...While and Do...Until Loops Avoiding Infinite Loops Executing a Procedure Line by Line Understanding While...Wend Loop Understanding For...Next Loop Understanding For...Each...Next Loop Exiting Loops Early Using a Do...While Statement Using Loops and Conditionals Summary Chapter 7 Storing Multiple Values in Excel VBA Programs: A Quick Introduction to Working with Arrays Understanding Arrays Using a One-Dimensional Array Using a Two-Dimensional Array Using a Dynamic Array Using Array Functions Troubleshooting Errors in Arrays Using the ParamArray Keyword Data Entry with an Array Sorting an Array with Excel Summary Chapter 8 Keeping Track of Multiple Values in Excel VBA Programs: A Quick Introduction to Creating and Using Collections Working with Built-in Collections Collections versus Arrays Watching the Execution of Your VBA Procedures Summary Chapter 9 Excel Tools for Testing and Debugging: A Quick Introduction to Testing VBA Programs Testing VBA Procedures Stopping a Procedure Using Breakpoints Using the Immediate Window in Break Mode Using the Stop and Assert Statements Using the Watch Window Using Quick Watch Using the Locals Windows and the Call Stack Dialog Box Navigating with Bookmarks Trapping Errors Stepping through VBA Procedures Terminating a Procedure Based on a Condition Summary Index
Donate to keep this site alive
To access the Link, solve the captcha.
1. Disable the AdBlock plugin. Otherwise, you may not get any links.
2. Solve the CAPTCHA.
3. Click download link.
4. Lead to download server to download.