Microsoft Excel 2021 Programming Pocket Primer
- Length: 482 pages
- Edition: 1
- Language: English
- Publisher: Mercury Learning and Information
- Publication Date: 2022-09-29
- ISBN-10: B0BGYF64HS
- 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 with Amazon proof of purchase from the publisher by writing to [email protected])
+Introduces you to using the VBA programming language in Microsoft Excel 2021.
Table of Contents
1. Excel Macros. 2. Excel Programming Environment. 3. Excel VBA Fundamentals. 4. Excel VBA Procedures.
5. Adding Decisions to Excel VBA Programs (Conditional Statements). 6. Adding Repeating Actions to Excel VBA Programs. 7. Adding Decisions to Excel VBA Programs (Arrays). 8. Keeping Track of Multiple Values in Excel VBA Programs. 9. Excel Tools for Testing and Debugging. Index.
About the Author
Since 1993, Julitta Korol (Long Island, NY) has published two dozen computer books on using and programming Microsoft Excel and Microsoft Access. She has completed professional certifications by Microsoft Corporation and the Computing Technology Industry Association (CompTIA).
Cover Title Copyright Page Contents Acknowledgments Introduction Chapter 1 Excel Macros: A Quick Start in Excel VBA Programming Macros and VBA Excel Macro-Enabled File Formats Macro Security Settings Enabling the Developer Tab in Excel Using the Built-In Macro Recorder Planning a Macro Recording a Macro Editing Recorded Macros Macro Comments Cleaning Up the Macro Code Running a Macro Testing and Debugging a Macro Saving and Renaming a Macro Printing Macro Code Improving Your Recorded Macros Creating a Master Macro Various Methods of Running Macros Running the Macro Using a Keyboard Shortcut Running the Macro from the Quick Access Toolbar Running the Macro from a Worksheet Button 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 List Properties/Methods List Constants Parameter Info Quick Info Complete Word Indent/Outdent Comment Block/Uncomment Block Using the Object Browser Locating Procedures with the Object Browser Using the VBA Object Library Using the Immediate Window Obtaining Information in the Immediate Window Working with Worksheet Cells and Ranges Using the Range Property Using the Cells Property Using the Offset Property Using the Resize Property Using the End Property Moving, Copying, and Deleting Cells Working with Rows and Columns Obtaining Information about the Worksheet Entering Data and Formatting Cells Returning Information Entered in a Worksheet Finding Out about Cell Formatting 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 Breaking Up Long VBA Statements Saving Results of VBA Statements Introducing Data Types Using Variables How to Create Variables How to Declare Variables Specifying the Data Type of a Variabl Assigning Values to Variables Forcing Declaration of Variables Understanding the Scope of Variables Procedure-Level (Local) Variables Module-Level Variables Project-Level Variables Lifetime of Variables Finding a Variable Definition Determining a Data Type of a Variable Using Constants Built-In Constants Converting between Data Types Using Static Variables in VBA Procedures Using Object Variables in VBA Procedures Using Specific Object Variables Summary Chapter 4 Excel VBA Procedures: A Quick Guide to Writing Function Procedures Understanding Function Procedures Creating a Function Procedure Various Methods of Running Function Procedures Running a Function Procedure from a Worksheet Running a Function Procedure from Another VBA Procedure Ensuring Availability of Your Custom Functions Passing Arguments to Function Procedures Specifying Argument Types Passing Arguments by Reference and Value Using Optional Arguments Testing a Function Procedure Locating Built-In Functions Getting to Know the MsgBox Function Returning Values from the MsgBox Function Getting to Know the InputBox Function Determining and Converting Data Types 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 Using Is with the Case Clause Specifying a Range of Values in a Case Clause Specifying Multiple Expressions in a Case Clause Writing a VBA Procedure with Multiple Condition 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 Declaring Arrays Array Upper and Lower Bounds Initializing and Filling an Array Filling an Array Using Individual Assignment Statements Filling an Array Using the Array Function Filling an Array Using For…Next Loop Using a One-Dimensional Array Using a Two-Dimensional Array Using a Dynamic Array Using Array Functions The Array Function The IsArray Function The Erase Function The LBound and UBound 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 Collections of Objects Declaring and Using a Custom Collection Adding Objects to a Custom Collection Determining the Number of Items in Your Collection Accessing Items in a Collection Removing Items from a Collection Updating Items in a Collection Returning a Collection from a Function Using Custom and Built-in Collections Together Collections Versus Arrays Watching the Executive 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 When to Use a Breakpoint Using the Immediate Window in Break Mode Using the Stop and Assert Statements Using the Watch Window Removing Watch Expressions Using Quick Watch Using the Locals Windows and the Call Stack Dialog Box Navigating with Bookmarks Trapping Errors Using the Err Object Setting Error Trapping Options in a VBA Project Stepping through VBA Procedures Stepping Over a Procedure and Running to Cursor Setting the Next Statement Showing the Next Statement Stopping and Resetting VBA Procedures Terminating a Procedure based on a Condition Summary Index
Donate to keep this site alive
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.