Events
May 19, 6 PM - May 23, 12 AM
Calling all developers, creators, and AI innovators to join us in Seattle @Microsoft Build May 19-22.
Register todayNote
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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).
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.
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.