Introducing Specialist Sliders

Specialist Sliders - Bars with a Button that you can Slide up and down to increase or decrease a value for a Range or Defined Name for Excel with Step Range and Optional Bar Scale

Specialist Sliders are small horizontal and vertical bars with Buttons that you click and then drag up or down to increase or decrease a value Range from 0 to 100 as default or a bespoke Range. Specialist Sliders have a coloured Slider Bar that sits underneath the Slider Button and expands or contracts as the Slider Button is dragged. These Sliders differ from other Sliders that I have created by the way that they lock into a position when dragged by the Mouse. When the Mouse Button is released the Slider Button will 'spring' to the nearest Step on the Scale. Slider Shapes are linked to Macros that enable this movement in pixels or in Steps as part of a Range that can shown visually as a Scale through a variety of different methods including a Chart Scale and Cell Formatting. Sliders have a Cursor Drag Coefficient and a Speed Coefficient. They can be set manually either by Cell adjustment or via a VBA Macro. Sliders use advanced Code to ease the setup, design and implementation together with Named Ranges to control their various attributes

Prerequisites

• Excel 2013 (Version 5) & Excel 2016 (32bit or 64bit, Version 8)
• Basic to moderate Excel Skills and some VBA skills to copy Shapes and then link a Subroutine to a Shape or a Graphic object
• Windows PC · NOT a Mac!
• No support is provided for customization of this Software

Features

• Code dynamically creates the minimum and maximum settings without any user interaction. This means that you can simply Copy the 3 Shapes required for each Specialist Slider, rename them Slider2, Slider2Bar, Slider2Placeholder, format them how you like and then just drag the Slider Button to see your masterpiece in action
• Optimised Code allows you to set the Slider Button as a Percentage of the Width of any designed Slider Bar and Slider Placeholder
• Specialist Sliders have a Cursor Drag Coefficient and a Speed Coefficient, which when combined together give a springy, resistance when pulling or dragging the Slider Buttons
• You can change the Custom Cell Format to be Percentage (%) or Numeric and the Code will detect the underlying Cell Format to give either 0%-100% or 0-100
• Draggable, Step SLiders. When these Slider Buttons are dragged they exhibit a springy feel and will lock into situ to the nearest Step once the Mouse Button is released
• Use a range for your Slider. Add a Named Range with a Suffix of Range ie. Slider6Range and use a Pipe-delimited String of Start and End numbers ie. 0|5 meaning 0 to 5 steps on the Slider. The Named Range should contain either 30|60 if using Numeric values or 30%|60% if using Percentage values
• Store the Slider values in the Sheet to Defined Names or a Range both as numbers or as a percentage
• Output the values after the Slider interaction is complete or dynamically as you scroll using the Slider Button
• Move the Slider anywhere in your Workbook
• Use Pattern Fills to emulate the Sliders in a RadiObutton style
• Protect the Shape and Graphic Drawing Objects via VBA Code to prevent Selection

More Info:

Online Documentation