Spin Button variable linked cell

Hi Ozz,

What value are you trying to change? The spin button will just add or subtract 1 to the linked cell. If 2012 February is supposed to be 2 why not just set E2 equal to 2 (which would be the value of the linked cell)?

Maybe, I'm just not understanding what you are trying to accomplish...

I'll try to explain a little better. The section of the main sheet where the spin buttons are has 10 cells that each have a value. The user can select those values and adjust them with the spin buttons, one for each cell. I have it set at 5, but have code to change them all to either 5, 10, 20, 50, or 100. Each of these cells shows the value for a certain month and year. In the data sheet I have, i have the months listed with the years, it starts at january 2012, and goes to the current month, and adds one month at the beginning of each month. Each cell has a vlookup to go to a certain cell on the data sheet, corresponding to the month and year that the user has selected.
The spin buttons change the values in the data sheet, which the cells on the main sheet just reference. What I want to do is when the month and or year is changed, to have the spin buttons linked cell move up or down rows, to correspond to the date selected. Say, if January 2012 is selected, spin button 1 would be linked to cell D1 on the data sheet, but if the user changes to February 2012, spin button 1 would be linked to cell D2; all the way to the end, so say if October 2013 is selected, spin button 1 would link to cell D12.
I have a formula that displays a number which is equal to the number of months since the start, and would like to use that as a reference for the row in the linked cell property, but can't figure out how to do it.

Here, why don't you upload your file at www.excelVBAmaster.com I'll do it for free for you. Just put in $0.01 per hour. I won't charge you.