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.