VBA - SelectionChange event in Add-in

[D4rwin]

I'm trying to create a "cell tracker" whereby a user is able to select a secondary cell to follow along the movements of the activecell in order to find corresponding data points in two side-by-side tables. I have been able to do this very simply on a single workbook and sheet by adding a button which prompts the user for which cell he would like to "track" and then selecting the union and following the activecell with the SelectionChange event.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

    If myTog = False Then Exit Sub
    Union(ActiveCell, ActiveCell.Offset(Track_Y, Track_X)).Select
    
End Sub

However, my ultimate goal is to include this functionality in an add-in. Therefore, I am wondering if there is a way to achieve a similar result without the ability to manipulate each individual worksheet. I hope my question was clear enough.

Thanks

 

[D4rwin]

Wow, this was certainly more than I was expecting. After a little tweaking it seems to be working perfectly. Thank you both very much for going above and beyond to help a stranger in need!