Excel Host Controls

Describes the extended functionality of Chart controls, including the addition of events and data binding.

Describes the extended functionality of ListObject controls, including the addition of events and data binding.

Describes the extended functionality of NamedRange controls, including the addition of events and data binding.

Describes the extended functionality of XmlMappedRange controls, including the addition of events and data binding.

Demonstrates how to create Excel Chart controls at design-time and programmatically during run-time.

Demonstrates how to add ListObject controls from the toolbox at design-time, and programmatically during run-time.

Provides information on adding NamedRange controls at design-time and run-time.

Describes how to map repeating XML elements to a worksheet in order to create XmlMappedRange controls.

Demonstrates how to use the Define Name dialog box to delete named ranges in Excel.

Describes how to set properties of NamedRange controls in order to resize it.

Demonstrates how to use the Resize list dialog box and also how to programmatically resize ListObject controls.

Describes how to use the Name Box or Properties window to locate NamedRange controls on a worksheet.

Describes how to use the BeforeAddDataBoundRow event to validate data before committing changes in the ListObject to the data source.

Describes how to use the ErrorAddDataBoundRow event to correct an error and attempt to add the row to the data source again.

Describes how to map specific columns within a ListObject control to a data source.

Demonstrates the creation of event handlers for the BeforeRightClick, SelectionChange and Change events of a NamedRange control.

Describes how column and row order changes made to a ListObject are preserved.

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.

Provides links to information on the new controls available to Word documents, known as host controls, and how to add them to a document.

Lists topics that show how to bind controls, including host controls, to data.