| Note | Required applications |
|---|---|
|
The features in this topic are available only if you have the required applications installed. For more information, see Features Available by Product Combination. |
|
Microsoft Visual Studio 2005 Tools for the Microsoft Office System extends the functionality of some important objects in Microsoft Office Excel 2003 so that they expose events and can be bound to data. This section describes the host controls available for Excel workbooks.
In This Section
- 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.
- 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.