Excel Sliders

[ComputerTrain]

Can you create sliders in Excel 2007? If so can anyone give me directions?

Thank you!

 

[jeffreybrown]

Are you talking about this...

http://www.math.ksu.edu/~bennett/m100/m100slider.pdf

 

[ComputerTrain]

Thank you for your reply. That is what a slider is, but that is in 2003. Do you know if it can be done in excel 2007?

 

[Titian]

This may help. I saved a 2003 file containg a slider as a 2007 ".xlsm" file.

Choose Developer/Controls/Toggle on Design Mode and you can copy the existing slider.

 

[jeffreybrown]

As Titian has already mentioned...go to Developer on the ribbon tab...select Controls and then pick out a Scroll bar. It should be in the vertical position, but if you want it horizontal then just grab it by the edge and spin it.

 

[ComputerTrain]

Thank you both. I couldnt find the 'cell link' field yesterday in the properties group. Must have missed it.

What an interesting 'secret' this is!

Thanks again