Excel 2007 : Slider?

Hi

I'm making a survey in XL and the scale is Strongly Disagree to Strongly Agree, I'd like for the recipient of the file to be able to simply move a slider to indicate their level of agreeance and this would capture a valur from 0-100 based on where the slider landed. EG if it landed in the middle, the output value would be 50.

This output value needs to be available to then build into graphs - is this possible - ive searched everywhere but can only find sliders for graphs.

Please help

Thanks

Simon

Richard

Appreciate your prompt reply, however I'm a real newbie to VBE and I wouldn't know where to start with that. Is there any chance you could be a little more specific or throw me to an example I could copy as my skills at this are way beneath yours. Thankyou

Richard, This is great and I definitely can use this. Is there any way of having lots of these all static on a page all at the same time - eg. 10 questions, 10 different sliders (userforms) without having to click the link to open the slider, so you open the sheet and there are already 10 sliders sat there waiting for you to update them? Also is there anyway to make it left to right instead of up and down.

Either way, you've really helped, if you can answer my other bits great, but if not, I'll see what I can do with the brilliant example you have sent me

Thanks

Simon

Richard - Ive sussed out how to make it go left to right but cant understand how to duplicate it for seperate questions all within one sheet

Regards, Simon

Richard - You're a genius!!. I've not exactly followed your example but ive inserted an activex scrollbar, set min and max values and linked to a cell, really simple. Ive attached my s/sheet. Is there anything wrong with using activex? other than some folks not trusting its content?

Thanks again - Brilliant

forgot to attach my example

Last question is - how do you post this as [SOLVED]. Well done and Thanyou