Walkthroughs using Excel

The following walkthroughs demonstrate ways you can use document-level customizations and VSTO Add-ins to automate Microsoft Office Excel and customize the user interface (UI).

Document-level walkthroughs

• Walkthrough: Create your first document-level customization for Excel Demonstrates how to create a basic document-level customization for Excel.

• Walkthrough: Create a custom tab by using the Ribbon designer Demonstrates how to add a custom tab to the Ribbon of an Excel workbook.

• Walkthrough: Collect 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: Display text in a text box in a worksheet using a button Demonstrates the basics of using buttons and text boxes on Excel worksheets.

• Walkthrough: Program 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: Create 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: Update a chart in a worksheet using radio buttons Shows the basics of changing chart styles using radio buttons on an Excel worksheet.

• Walkthrough: Bind 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.

Application-level walkthroughs

• Walkthrough: Create your first VSTO Add-in for Excel Demonstrates how to create a basic VSTO Add-in for Excel.

• Walkthrough: Add controls to a worksheet at run time in VSTO Add-in project Demonstrates how to add controls to a worksheet by using a VSTO Add-in.

• Walkthrough: Call code in a VSTO Add-in from VBA Demonstrates how to expose an object in a VSTO Add-in to VBA code in a workbook.

• Walkthrough: Synchronize a custom task pane with a Ribbon button Demonstrates how to create a custom task pane that users can hide or display by clicking a toggle button on the ribbon.