Walkthroughs Using Excel

Applies to
The information in this topic applies only to the specified Visual Studio Tools for Office projects and versions of Microsoft Office. Project type Document-level projects Application-level projects Microsoft Office version Excel 2003 Excel 2007 For more information, see Features Available by Application and Project Type.

Walkthroughs provide step-by-step instructions for common scenarios and are a good place to start learning about Visual Studio Tools for Office.

The following walkthroughs demonstrate several basic types of tasks: automating Microsoft Office Excel, performing data analysis, working with controls, deploying solutions, and setting security.

Walkthroughs for Excel 2007

The following walkthroughs demonstrate tasks that require Excel 2007.

• Walkthrough: Creating a Custom Tab by Using the Ribbon Designer
  Demonstrates how to add a custom tab to the Ribbon of an Excel 2007 workbook.

Walkthroughs for Excel 2007 and Excel 2003

The following walkthroughs demonstrate tasks that can be performed with Excel 2007 and Excel 2003.

• Walkthrough: Collecting Data Using a Windows Form
  Illustrates using a Windows Form to collect user input and then sending the input to a cell in an Excel worksheet.

• Walkthrough: Changing Worksheet Formatting Using CheckBox Controls
  Demonstrates the basics of using check boxes on an Excel worksheet to change formatting.

• Walkthrough: Displaying Text in a Text Box in a Worksheet Using a Button
  Demonstrates the basics of using buttons and text boxes on Excel worksheets.

• Walkthrough: Programming Against Events of a NamedRange Control
  Provides step-by-step instructions on how to add a NamedRange control to a worksheet and program against its events.

• Walkthrough: Simple Data Binding in a Document-Level Project
  Demonstrates the basics of binding a single data field in a SQL Server database to a named range in Excel.

• Walkthrough: Complex Data Binding in a Document-Level Project
  Demonstrates the basics of binding multiple cells in an Excel worksheet to fields in the Northwind SQL Server database.

• Walkthrough: Creating a Master/Detail Relation Using a Cached Dataset
  Demonstrates creating a master/detail relation on a worksheet, and caching the data so that the solution can be used offline.

• Walkthrough: Updating a Chart in a Worksheet Using Radio Buttons
  Shows the basics of changing chart styles using radio buttons on an Excel worksheet.

• Walkthrough: Binding Data to Controls on an Excel Actions Pane
  Describes how to add controls that are bound to a data source to an actions pane in Excel.