Slide Bar

P

PeterWilliams

Hi,
How do I put in a slide bar so that, for example, data from 1 to 10 can
be selected? Does the value selected get stored in a cell or does it
need to be embedded in a macro or vba code?

Thanks in advance.
 
B

Bryan Hessey

You can View, Toolbars and select 'Control Toolbox'. Select the first
icon Design Mode, then select the 'Scroll Bar' and draw it's position.

Rightmouse on the slide and select Properties. Set Min to 1, Max to 10,
and Linked Cell to the desired Address.

Click the 'Exit Design Mode' to complete.

--
 
Top