Microsoft Office Excel 2007 Programming : Your Visual Blueprint for Creating Interactive Spreadsheets

by Etheridge, Denise

• ISBN13: 9780470132302
• ISBN10: 0470132302
• Edition: 1st
• Format: Paperback
• Copyright: 2007-09-11
• Publisher: Visual

Summary

Microsoftr Office Excelr 2007 ProgrammingWelcome to the only guidebook series that takes a visual approach to professional-level computer topics. Open the book and you'll discover step-by-step screen shots that demonstrate over 140 key Excel programming techniques, including:Assigning digital signatures to macrosSetting properties for a projectAssigning values to a variableChanging the properties of an objectFormatting a numeric expressionProcessing a runtime errorSaving worksheets to another fileDisplaying a built-in dialog boxCreating custom Ribbon tabsBuilding and debugging add-insExtra Apply It"Apply It" and "Extra" sidebars highlight useful tipsHigh-resolution screen shots demonstrate each taskSuccinct explanations walk you through step by stepTwo-page lessons break big topics into bite-sized modules

Author Biography

Denise Etheridge is a certified public accountant as well as the president and founder of Baycon Group, Inc. She publishes Web sites, provides consulting services on accounting-related software, and authors computer-related books. You can visit www.baycongroup.com to view her online tutorials.

Table of Contents

How To Use This Book

Using Macros And Form Controls

Introducing Excel Programming

Introducing Macros

Set Macro Security

Create a Digital Signature

Record a Macro

Assign a Digital Signature to a Macro

Run a Macro

Create and Launch a Keyboard Shortcut

Assign a Macro to the Quick Access Toolbar

Delete a Macro

Add a Form Control to a Worksheet

Assign Values to a Form Control

Add a Macro to a Form Control

Using The Visual Basic Editor

Introducing the Visual Basic Editor

Activate the Visual Basic Editor

Open Visual Basic Editor Windows

Set Properties for a Project

Set Display Options for the Code Window

Add a New Module

Remove a Module

Hide a Macro

Update a Macro

Introducing Visual Basic For Applications

Create Sub Procedures

Create Functions

Comment Your Code

Understanding Variables and Data Types

Reference Cells and Ranges

Declare Variables

Work with Numbers

Work with Strings

Create a Constant

Introducing The Excel Object Model

Discover the Excel Object Model

Access the Excel Object Model Reference

Create an Object Variable

Change the Properties of an Object

Compare Object Variables

Using an Object Method

Display a Built-in Dialog Box

Understanding Arrays

Declare an Array

Declare a Multidimensional Array

Convert a List to an Array

Redimension an Array

Create a User-Defined Data Type

Controlling Program Flow

Create Comparisons

Make Use of Logical Operators

Employ Do While Loops

Create Do Until Loops

Create For Next Loops

Execute For Each In Loops

Create If Then Else Statements

Construct Select Case Statements

GoTo a Named Location

Call a Procedure

Using Excel Worksheet Functions

Work with Excel Worksheet Functions

Work with a MsgBox Function

Using the InputBox Function

Retrieve the Current Date and Time

Perform Date and Time Calculations

Format a Date Expression

Format a Numeric Expression

Change the Case of a String

Return a Portion of a String

Debugging Macros

Debug a Procedure with Inserted Break Points

Using the Watches Window to Debug a Procedure

Step through a Procedure

Use the Immediate Window

Resume Execution When an Error Is Encountered

Process a Run-Time Error

Working With Workbooks And Files

Open a Workbook

Open a Text File as a Workbook

Open a File Requested by the User

Save a Workbook

Save a Workbook in a Format Specified by the User

Determine if a Workbook Is Open

Close a Workbook

Create a New Workbook

Delete a File

Working With Worksheets

Add a Sheet

Delete a Sheet

Move a Sheet

Copy and Paste a Sheet

Hide a Sheet

Change the Name of a Sheet

Save a Sheet to Another File

Protect a Worksheet

Protect a Chart

Print a Sheet

Sort Worksheets by Name

Defining

Table of Contents provided by Publisher. All Rights Reserved.