Worksheet Change Event and EXCELDNA with C#

[Jim]

Hi,
I need to subscribe to an event Worksheet_Change to get added values from sheet
once they are added. Currently I am using Timer to scan my worksheet. 
I would like to do it in ExcelDNA with C#


VBA code

Private Sub Worksheet_Change(ByVal Target As Range)
    'here, check whether Target, a Range, is one of your "trigger" cells,
    'and if it is, react accordingly

      MainSheetHasChanged = True
 End Sub

By the way are there any other ways to do it more efficiently.

thanks

[pb19...@gmail.com]

 public class Class1 : IExcelAddIn

{

Microsoft.Office.Interop.Excel.Application xlapp = (Microsoft.Office.Interop.Excel.Application)ExcelDnaUtil.Application;

      //  int eventCounter = 0;

        Workbook Wb_ ;

        public void AutoOpen()

        {

                        xlapp.WorkbookActivate += xlapp_WorkbookActivate;

        }

        void xlapp_WorkbookActivate(Workbook Wb)

        {

            Wb.SheetChange += Wb_SheetChange;

            System.Windows.Forms.MessageBox.Show("in activate");

            Microsoft.Office.Interop.Excel.Worksheet ws = Wb.ActiveSheet;

        }

        void Wb_SheetChange(object Sh, Microsoft.Office.Interop.Excel.Range Target)

        {

}

}

This might helps you.