Thread: Linking a Macro to a row

Hi,

I've created a button on each line of my document. This button opens up a userform and I want this userform linked to that row. At the moment, I have the button select the cell and run Macro:

Sub EditB110()
Range("B2").Select
Application.Run "'Calendar test.xls'!OpenAccEntry.OpenAccEntry"
End Sub

Instead of selecting "B2", is there a way to determine which row the button is in and then select the next corresponding cell? For example: if button is in A1, then I want the macro to find it is in row A and then select A2 and run macro.

Thanks,
Jason