Excel Host Controls
The information in this topic applies only to the specified Visual Studio Tools for Office projects and versions of Microsoft Office.
For more information, see Features Available by Application and Project Type.
Visual Studio Tools for Office extends the functionality of some important objects in Microsoft Office Excel so that they expose events and can be bound to data. This section describes the host controls available for Excel workbooks.
In This Section
How to: Delete NamedRange Controls at Design Time
Demonstrates how to use the Define Name dialog box to delete named ranges in Excel.
How to: Validate Data When a New Row is Added to a ListObject Control
Describes how to use the BeforeAddDataBoundRow event to validate data before committing changes in the ListObject to the data source.
How to: Handle Errors When a New Row is Added to a ListObject Control
Describes how to use the ErrorAddDataBoundRow event to correct an error and attempt to add the row to the data source again.
Walkthrough: Programming Against Events of a NamedRange Control
Demonstrates the creation of event handlers for the BeforeRightClick, SelectionChange and Change events of a NamedRange control.
Understanding ListObject Column and Row Order Persistence
Describes how column and row order changes made to a ListObject are preserved.
Host Items and Host Controls Overview
Describes the relationship between host items and host controls, as well as the additional functionality that has been added to the native objects upon which they are based.
Word Host Controls
Provides links to information on the new controls available to Word documents, known as host controls, and how to add them to a document.
Binding Data to Controls in Office Solutions
Lists topics that show how to bind controls, including host controls, to data.