Microsoft Excel 2016 Programming by Example : With VBA, XML, and ASP

A practical, how-to book on Excel programming, suitable for readers already familiar with the Excel user interface, this book introduces programming concepts via numerous multi-step, illustrated, hands-on exercises. --

Saved in:
Bibliographic Details
Main Author Korol, Julitta (Author)
Format Electronic eBook
LanguageEnglish
Published Dulles, Virginia : Mercury Learning and Information, 2017.
Subjects
Microsoft Excel (Computer file)
Electronic spreadsheets.
Visual programming (Computer science)
elektronické knihy
electronic books
Online AccessFull text
ISBN9781944534516
1944534512
9781523112609
1523112603
1942270852
9781942270850
Physical Description1 online resource

Cover

Table of Contents:
  • Cover
  • Title Page
  • Copyright
  • Contents
  • Acknowledgments
  • Introduction
  • Part I Excel VBA Primer
  • 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
  • Hands-On 1.1. Setting Up Excel for Macro Development
  • Using The Built-In Macro Recorder
  • Planning a Macro
  • Hands-On 1.2. Getting Things Ready for Macro Recording
  • Recording a Macro
  • Hands-On 1.3. Inserting and Naming a Worksheet (Macro Task 1)
  • Hands-On 1.4. Inserting Column Headings and Applying Formatting (Macro Task 2)
  • Hands-On 1.5. Entering Employee Data (Macro Task 3)
  • Hands-On 1.6. Entering Formulas to Fill in Employee First Name (Macro Task 4)
  • Hands-On 1.7. Entering Formulas to Fill in Employee Last Name (Macro Task 5)
  • Hands-On 1.8. Entering Formulas to Calculate Employee Total Wages (Macro Task 6)
  • Hands-On 1.9. Applying Table Format (Macro Task 7)
  • Editing Recorded Macros
  • Hands-On 1.10. Examining the Macro Code
  • Macro Comments
  • Hands-On 1.11. Adding Comments to the Macro Code
  • Cleaning Up the Macro Code
  • Hands-On 1.12. Cleaning Up the Macro Code
  • Running a Macro
  • Hands-On 1.13. Running a Macro Using the Macro Dialog Box
  • Testing and Debugging a Macro
  • Hands-On 1.14. Running a Macro from the VBE Screen
  • Saving and Renaming a Macro
  • Hands-On 1.15. Saving Macros and Running Macros from Another Workbook
  • Printing Macro Code
  • Hands-On 1.16. Printing Macro Code
  • Improving Your Recorded Macros
  • Hands-On 1.17. Adding Visual Basic Statements to the Recorded Macro Code
  • Creating a Master Macro
  • Hands-On 1.18. Creating a Master Macro Procedure
  • Various Methods Of Running Macros
  • Running the Macro Using a Keyboard Shortcut
  • Hands-On 1.19. Assigning a Macro to a Keyboard shortcut.
  • Running the Macro from the Quick Access Toolbar
  • Hands-On 1.20. Running a Macro from the Quick Access Toolbar
  • Running the Macro from a Worksheet Button
  • Hands-On 1.21. Running a Macro from a Button Placed on a Worksheet
  • Summary
  • Chapter 2 Excel Programming Environment
  • A Quick Overview of Its Tools and Features
  • 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
  • Hands-On 2.1. Indenting/Outdenting Visual Basic Code
  • Comment Block/Uncomment Block
  • Using The Object Browser
  • Hands-On 2.2. Writing a VBA Procedure to Move a Text Box on the Worksheet
  • Hands-On 2.3. Writing a VBA Procedure to Move a Circle on the Worksheet
  • Locating Procedures with the Object Browser
  • Hands-On 2.4. Using Object Browser to Locate VBA Procedures
  • Using the VBA Object Library
  • Hands-On 2.5. Writing a VBA Procedure to Create a Folder in Windows
  • Using the Immediate Window
  • Hands-On 2.6. Entering and Executing VBA Statements in the Immediate Window
  • Obtaining Information in the Immediate Window
  • Hands-On 2.7. Obtaining Information in the Immediate Window
  • Working with Worksheet Cells and Ranges
  • Using the Range Property
  • Hands-On 2.8. Practice Using the Range Property to Select Worksheet Cells
  • Using the Cells Property
  • Hands-On 2.9. Practice Using the Cells Property to Select Worksheet Cells (Part I)
  • Hands-On 2.10. Practice Using the Cells Property to Select Worksheet Cells (Part II)
  • Using the Offset Property
  • Hands-On 2.11. Selecting Cells Using the Offset Property
  • Using the Resize Property
  • Hands-On 2.12. Writing a VBA Statement to Resize a Selection of Cells.
  • Using the End Property
  • Hands-On 2.13. Selecting Cells Using the End Property
  • Moving, Copying, and Deleting Cells
  • Hands-On 2.14. Moving, Copying, and Deleting Cells
  • Working with Rows and Columns
  • Hands-On 2.15. Selecting Entire Rows and Columns
  • Obtaining Information about the Worksheet
  • Hands-On 2.16. Counting Rows and Columns
  • Entering Data and Formatting Cells
  • Hands-On 2.17. Using VBA Statements to Enter Data in a Worksheet
  • Returning Information Entered in a Worksheet
  • Finding Out about Cell Formatting
  • Working with Workbooks and Worksheets
  • Hands-On 2.18. Working with Workbooks
  • Hands-On 2.19. Working with Worksheets
  • Working with Windows
  • Hands-On 2.20. Working with Windows
  • Working with the Excel Application
  • Hands-On 2.21. 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 Variable
  • Assigning Values to Variables
  • Hands-On 3.1. Writing a VBA Procedure with Variables
  • Forcing Declaration of Variables
  • Hands-On 3.2. Writing a VBA Procedure with Explicitly Declared Variables
  • Understanding the Scope of Variables
  • Procedure-Level (Local) Variables
  • Module-Level Variables
  • Hands-On 3.3. Writing a VBA Procedure with a Module-Level Variable
  • Project-Level Variables
  • Lifetime of Variables
  • Finding a Variable Definition
  • Determining a Data Type of a Variable
  • Hands-On 3.4. Using the Built-In VarType Function
  • Using Constants
  • Built-In Constants.
  • Hands-On 3.5. Viewing Excel Constants in the Object Browser
  • Converting between Data Types
  • Hands-On 3.6. Using Data Type Conversion Functions in VBA
  • Hands-On 3.7. Writing a VBA Procedure with a Static Variable
  • Using Object Variables in VBA Procedures
  • Hands-On 3.8. Writing a VBA Procedure with Object Variables
  • Using Specific Object Variables
  • Summary
  • Chapter 4 Excel VBA Procedures
  • A Quick Guide to Writing Function Procedures
  • Understanding Function Procedures
  • Creating a Function Procedure
  • Hands-On 4.1. Writing a Simple Function Procedure
  • Various Methods of Running Function Procedures
  • Running a Function Procedure from a Worksheet
  • Hands-On 4.2. Executing a Function Procedure from within an Excel Worksheet
  • Running a Function Procedure from Another VBA Procedure
  • Hands-On 4.3. Executing a Function from a VBA Procedure
  • Ensuring Availability of Your Custom Functions
  • Passing Arguments to Function Procedures
  • Hands-On 4.4. Passing Arguments to Functions (Example 1)
  • Specifying Argument Types
  • Hands-On 4.5. Passing Arguments to Functions (Example 2)
  • Passing Arguments by Reference and Value
  • Hands-On 4.6. Passing Arguments to Functions (Example 3)
  • Using Optional Arguments
  • Hands-On 4.7. Writing Functions with Optional Arguments
  • Testing a Function Procedure
  • Locating Built-In Functions
  • Getting to Know the MsgBox Function
  • Hands-On 4.8. Formatting Text for Display in the MsgBox Function
  • Hands-On 4.9. Using the MsgBox Function with Arguments (Example 1)
  • Hands-On 4.10. Using the MsgBox Function with Arguments (Example 2)
  • Returning Values from the MsgBox Function
  • Hands-On 4.11. Using the MsgBox Function with Arguments (Example 3)
  • Getting to Know the InputBox Function
  • Hands-On 4.12. Using the InputBox Function (Example 1)
  • Determining and Converting Data Types.
  • Hands-On 4.13. Using the InputBox Function (Example 2)
  • Using the InputBox Method
  • Hands-On 4.14. Using the Excel 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
  • Hands-On 5.1. Evaluating Conditions in the Immediate Window
  • Hands-On 5.2. Writing a VBA Procedure with a Simple If...Then Statement
  • Using If...Then...Else Statement
  • Hands-On 5.3. Writing a VBA Procedure with an If Then...Else Statement
  • Using If...Then...ElseIf Statement
  • Hands-On 5.4. Writing a VBA Procedure with an If...Then...ElseIf Statement
  • Nested If...Then Statements
  • Using the Select Case Statement
  • Hands-On 5.5. Writing a VBA Procedure with a 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 Conditions
  • Hands-On 5.6. Writing a VBA Procedure with Multiple Conditions
  • Using Conditional Logic in Function Procedures
  • Hands-On 5.7. Writing a Function Procedure with a Select Case Statement
  • 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
  • Hands-On 6.1. Writing a VBA Procedure with a Do... While Statement
  • Hands-On 6.2. Writing a VBA Procedure with a Do... Until Statement
  • Avoiding Infinite Loops
  • Executing a Procedure Line by Line
  • Hands-On 6.3. Executing a Procedure Line by Line
  • Understanding While...Wend Loop
  • Hands-On 6.4. Writing a VBA Procedure with a While... Wend Statement
  • Understanding For...Next Loop
  • Hands-On 6.5. Writing a VBA Procedure with a For... Next Statement
  • Understanding For...Each...Next Loop.

Similar Items