Export (0) Print
Expand All

Excel Host Controls

Applies to

The information in this topic applies only to the specified Visual Studio Tools for Office projects and versions of Microsoft Office.

Document-level projects

  • Excel 2007

  • Excel 2003

Application-level projects

  • Excel 2007

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.

Chart Control

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

ListObject Control

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

NamedRange Control

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

XmlMappedRange Control

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

How to: Add Chart Controls to Worksheets

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

How to: Add ListObject Controls to Worksheets

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

How to: Add NamedRange Controls to Worksheets

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

How to: Add XMLMappedRange Controls to Worksheets

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

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: Resize NamedRange Controls

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

How to: Resize ListObject Controls

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

How to: Locate NamedRange Controls on a Worksheet

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

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.

How to: Map ListObject Columns to Data

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

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.

Community Additions

ADD
Show:
© 2015 Microsoft