Introducing Sliders

Sliders - Bars with a Button that you can Slide back and forth to increase or decrease a value for a Range or Defined Name for Excel

Sliders are small bars with Buttons that you click and then drag left or right to increase or decrease a value range from 1 to 100. Slider can have a coloured Slider Bar that sits underneath them and expands or contracts as the Slider Button is dragged. Slider Shapes are linked to Macros that enable their movement and can be Zoomed in a Worksheet. Sliders can be set dynamically either by Cell adjustment or via a VBA Macro. From Version 1.4 Sliders_2022 use rewritten, advanced Code to ease the setup, design and implementation of the Slider Shapes

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. Also, the ability to edit the Code and adjust some Constants in the Macros for bespoke Sliders
• Windows PC · NOT a Mac!
• No support is provided for customization of this Software

Features

• From Version 1.4 I have changed the Code to allow you to dynamically create the minimum and maximum settings without any user interaction. This means that you can simply Copy the 3 Shapes required for each 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
• 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
• 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
• Adjust the length of travel of the Slider and output the value or choose to maintain between a fixed range ie. 0-100 or 1-100 (useful as a percentage ie. 50 would equal 50%)
• Put the Slider ontop of a coloured Bar that expands or contracts as you drag the Slider Button along
• 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