Excel 2007 : Slider?

**Richard Buttrey** · 01-07-2010, 07:41 AM

Hi,

In the VBE you could add a UserForm and include a 'Scroll Bar' control, setting the Max & Min property values to 0 & 100, and the Control Source property to the cell where you want the result to appear.

HTH

**blackpoolrocks** · 01-07-2010, 08:30 AM

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 Buttrey** · 01-07-2010, 11:11 AM

Hi,

I'm attaching a sample workbook which hopefully you can use as an example.

Regards

**blackpoolrocks** · 01-07-2010, 06:21 PM

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

**blackpoolrocks** · 01-07-2010, 06:41 PM

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

**blackpoolrocks** · 01-07-2010, 07:10 PM

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

**blackpoolrocks** · 01-07-2010, 07:11 PM

forgot to attach my example

**Richard Buttrey** · 01-08-2010, 06:56 AM

Hi,

I'm not aware of any real practical downsides to Activex controls. I personally think they are more flexible than the earlier Forms controls, (not to be confused with the VBA User Forms on which you can overlay an Activex Control). Jon Peltier has an article about them here http://peltiertech.com/WordPress/for...rols-in-excel/ which you may find useful.

Regards

**Richard Buttrey** · 01-07-2010, 06:45 PM

Hi Simon,

See the revised example on Sheet2. I've avoided the user form approach and put the slider control as an embedded object on the sheet. Right click the control to see the properties after selecting Design Mode. Copy and paste it as necessary for other questions.

Regards