I have built an interactive carbon reduction model which populates baseline performance around a series of activities i.e. business mileage, energy efficiency etc. I am then using sliders to allow the user to view the effect of improving their behaviour in related activity. This enables me to auto calculate the benefits (or not) from change, however, I am not an excel or VB expert and are having real probs resetting the graph back to the original values (trying to use command buttons).
I realise this isnt difficult but just cant get it to work.
What I would like to do is be able to reset button the value linked to each scroll bar as well as reset button covering all scroll bars in the sheet back to the baseline default (the default value sits in another coloumn in the same row as the graph source value).
Can anyone advise on the VB command direction behind the command button?
Cheers
Kevin