how to set the active cell to the macro button's location?

hi all

i have a command button object with the following code:

Please Login or Register  to view this content.

so i am trying to write the file path (selected by the user) into a cell with the same row number of the command button.
so i thought the "ActiveCell" will automatically be the cell behind the command button, but apparently it is not so...

how do i set the active cell to always be the cell behind the command button?
or do you have a different idea on how to get the location VA Brief Template.xlsm(row number) where the command button is?

i am going to have 96 buttons per sheet, plus 9 duplicates of this sheet, so i really need a generic code to by dynamic and fit all buttons...
see attached file as an example for what i need...

thanks!
R.T

sorry, i got the attachment text "VA Brief Template.xlsm" in the middle of the lines..

You could assign all your buttons that do this thing to this one macro. It will determine the button that called the macro and reference the cell in the button's top left corner and offset one column to it's right.

Please Login or Register  to view this content.

Edit: ...just like Leith Ross suggests.

wow!! thanks so much for this quick help!!
youre really great!