Microsoft Excel 2021 Programming Pocket Primer
This book was designed for someone like you who needs to master Excel programming fundamentals without spending too much time. --
Saved in:
Online Access: |
Full text (MCPHS users only) |
---|---|
Main Author: | |
Format: | Electronic eBook |
Language: | English |
Published: |
Bloomfield :
Mercury Learning & Information,
2022
|
Series: | Computing Ser.
|
Subjects: | |
Local Note: | ProQuest Ebook Central |
Table of Contents:
- 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