Hi all,
I have a chart which forecasts revenue by month, and there are spin buttons associated with each month to increase or decrease the forecast for any month (please see image in attachment). There are actually 100 charts, each representing a different retail category.
Is there a way to use VBA so that the spin buttons automatically link to the cell below it? At the moment when I make a copy of the chart and the buttons, the buttons continue linking to the original cell.
E.g. Chart 1 has 12 spin buttons which are assigned to A5, B5, C5, D5, E5, etc.
I made chart 2 by copying and pasting over chart 1. Now chart 2 as 12 spin buttons, but these are also linked to A5, B5, C5, D5, etc. I want Chart 2's buttons to be linked to A10, B10, C10, D10, E10, etc.
Any help would be greatly appreciated. I only know how to do this by manually changing the property, which I do not want to do 100 times!
Thanks in advance
Bookmarks