VB.NET - Communication between Excel Add-In and Workbook

First, I'd like to say that I just started off working with VB.net and Visual Studio, so the solution to my problem may be really obvious to someone who has been working with it for a while. Also, my terminology may be a little mixed up as I'm using Visual Studio in another language. This website has already helped me a lot, but now I stumbled upon a problem that Google couldn't solve.

The goal of the application I'm writing is to have an add-in that reads from a database and puts a database table's content into an excel spreadsheet. The user may now alter any data in the spreadsheet and hit a seperate 'save'-button inside the add-in which will make the add-in write the changed rows back into the database. Writing and reading the cells isn't an issue.

After selecting a database and table in the add-in it creates a new workbook and writes into the cells.

My problem is the communication between the Excel Add-In and the workbook. All I need is to access the workbook_changed or worksheet_changed event to set a flag which rows have been changed or let the add-in know which cells (or at least rows) have been altered.

At the moment my project catalog only contains the addin. Should I add a excel-workbook project?


Thank you for reading all this, I really hope someone can help me.

I found an event in the addin that fits my needs, but since I'm filling the excel-sheet cell by cell the event is called every time the add-in writes into it. I solved that problem by adding a boolean that is set to true every time the add-in is writing.

    Private Sub Application_SheetChange(ByVal Sh As Object, ByVal Target As Microsoft.Office.Interop.Excel.Range) Handles Application.SheetChange
        If Not filling Then
            MsgBox("Yay!!!")
        End If
    End Sub