Excel 2007 : Slider?

**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

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

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

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

Hi,

In the blue bar at the top of the forum is a 'How To...? section. Just click this and read how to mark posts as solved.

Regards

**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