XmlMappedRange.Change Event

Reference

Definition

Namespace:: Microsoft.Office.Tools.Excel

Assembly:: Microsoft.Office.Tools.Excel.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

Occurs when something changes in the XmlMappedRange control.

public:
 event Microsoft::Office::Interop::Excel::DocEvents_ChangeEventHandler ^ Change;

event Microsoft.Office.Interop.Excel.DocEvents_ChangeEventHandler Change;

member this.Change : Microsoft.Office.Interop.Excel.DocEvents_ChangeEventHandler

Event Change As DocEvents_ChangeEventHandler

Event Type

DocEvents_ChangeEventHandler

Examples

The following code demonstrates a handler for the Change event that displays the address of the XmlMappedRange that changed. This code example assumes that the current worksheet contains an XmlMappedRange named CustomerLastNameCell.

private void XmlMappedRange_Change()
{
    this.CustomerLastNameCell.Change += 
        new Excel.DocEvents_ChangeEventHandler(
        CustomerLastNameCell_Change);
}

void CustomerLastNameCell_Change(Excel.Range Target)
{
    string changedRange = Target.get_Address(Excel.XlReferenceStyle.xlA1);

    MessageBox.Show("The value of " + this.Name + ":" +
        changedRange + " has been changed.");
}

Sub CustomerLastNameCell_Change(ByVal Target As Excel.Range) _
    Handles CustomerLastNameCell.Change
    Dim changedRange As String = Target.Address( _
        ReferenceStyle:=Excel.XlReferenceStyle.xlA1)
    MsgBox("The value of " & Me.Name & ":" & changedRange & _
        " has been changed.")
End Sub

Remarks

This event is raised if the XmlMappedRange control is changed by either a programmatic modification or user interaction. This event does not occur when the XmlMappedRange control changes during a recalculation.

Applies to

Share via