I am working on a large spreadsheet in which I have 200 form buttons (spin buttons) that can be used to change the value of the cell next to each individual button. I want to have a macro run on the values in the same row as the button and the cell that the button is linked to. Instead of creating 200 individual macros I would like to have one macro that reads either the row of the button or the row of the cell that the button is linked to and then runs a function on that row only. There is a simplified example attached for clarification. Any help will be greatly appreciated.

Example.xls