VBA to make 4 buttons assigned macros that change the link, max/min, small change.

[james0577]

I have macros assigned to 4 images. Everytime an image is clicked on a macro runs and cool stuff happens, however, one thing I need to be able to do is re-assign the link, max/min, small change to (lets say) spinbutton1 for example. For example, if i click on 1 image it runs macro "Cool_Stuff_1" and within the macro, I need vba that will assign the link to "$A$1" and have a small change of $25 with a min and max of 0 and 5000. Lets say then the second image triggers "Cool_Stuff_2" and then the same spinbutton1 will be re-assigned a link of $B$1 and the increment will be .05 with a min and max of 0 to 1, and so on.

It would also be nice, so that when the macro runs, the "value" is the value that already exists in the control source so that it can pick up where it left off.......

Thanks in advance.