Linking a Userform Multiple 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 EditB2()
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, I would click on button, then the macro would find what row the button is in, then select the next cell (A2) and run macro.

Thanks,
Jason

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here