Slide Bar
 

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.


--
PeterWilliams
------------------------------------------------------------------------
PeterWilliams's Profile: http://www.excelforum.com/member.php...o&userid=34438
View this thread: http://www.excelforum.com/showthread...hreadid=542012

Slide Bar
 

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.

--

PeterWilliams Wrote:
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.


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=542012