How to make the spin button's linked cell vary

[Irascivel]

Hello all,

Let me explain what I pretend:

I have plotted a chart in excel for a product anual sales and forecasts. I've created a drop list to select the product upon which the graph is updated. That works perfectly.

But now I want to put a spin button next to the graph that changes a parameter in forecast's formula.
Depending on the chosen product, the spin button should change the respective parameter value for that product - which is also the linked cell for the button.

I've come with a simple code and put it in the Spin Button object, but it doesn't work (note that I'm not a vba expert....)
Code:

Please Login or Register  to view this content.

What am I doing wrong? Thanks for your help!

[JBeaucaire]

http://www.mrexcel.com/forum/showthread.php?t=406686

[mudraker]

Your post does not comply with Rule 8 of our Forum RULES. Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser)to the cross-post. Expect cross-posts without a link to be closed a message will be posted by the moderator explaining why. We are here to help so help us help you!