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
Bookmarks