Introduction

Introducing Flat UI for Excel

Flat UI Interface Objects for Excel 2016 (32bit or 64bit, Version 16)

Flat UI Interface Objects are a collection of Grouped Shapes that can be used to provide interaction to change or update a Setting or Option in Excel. They are taken from various different Projects I currently have for sale and modified for this Project, Flat UI. Each Grouped set of Shapes can be moved around a Sheet or copied into another Workbook and configured accordingly by adding any required Defined Names (Named Ranges) and linking the relevant Macros to the individual Shapes. I include Checkboxes and Radiobuttons with Textboxes that can also be used to change the selection of a Checkbox or Radiobutton. You can use a Square or a Tick for the Checkboxes. I also include Toggle Buttons, a Slider and a Step Slider

For a Radiobutton both the Index or the Text from the Textbox Option can be captured by the Code output. For a Slider you can set it to output values between 0-10, 1-10, 0-100 or 1-100 or use a percentage (%). The Slider output can be Rounded to whole numbers of left with decimal places. For the rest of the Flat UI Objects (aside from the Popup Button) the outputs are all captured as TRUE/FALSE - this can easily be changed in the Code should you want a value like 0 or 1 instead (in case of Country specific Boolean True/False language issues)

Version 1.5 introduces my latest Flat UI Sliders using Awesome Slider Code. Awesome Sliders are the culmination of all of my work over the last few years producing Sliders for Excel. Those who have purchased and love the existing Slider Projects will know the nuances of pulling together a bespoke Slider design using my previous Code. This piece of work addresses some of those nuances, fundamentally changing the methods of dragging the Slider Buttons and building a Range. So what's changed? Well first off, the Mouse movement and how you drag the Slider Button Shapes is different. Now using the Mouse you can drag a Slider Button left/right or up/down depending on the Type of Slider being used without any resistance or delay in movement; you simply grab the Slider Button with the Mouse and put it exactly where you want it. This allows for a really dynamic look and feel to the Slider and puts the user in full control of the Button. You can rapidly drag it back and forth between the full Range within the allowed Scale

If you like this Project you may also enjoy


Awesome Sliders ·  Specialist Sliders ·  Sliders ·  Vertical Sliders ·  Slider Toggle Buttons ·  Awesome Buttons ·  Sliders ·  Small Toggle Buttons ·  Menubar ·  Toggle Buttons ·  xlui ·  RadiObutton ·  CheckboX ·  Burger Buttons ·  Popup Burger Buttons

Prerequisites

  • Microsoft Excel 2016 Version 16 (32bit or 64bit) · designed for Office 365
  • Basic to moderate Excel Skills and some VBA skills to copy Shapes and then link a Subroutine to a Shape or a Graphic object. Some editing of the Shapes may also be required ie. to update the Alt. Text Property or resize the Flat UI Objects
  • Windows PC · NOT a Mac!
  • No support is provided for customization of this Software

Features

  • Copy the Flat UI Objects as a Group of Shapes
  • Move the selected Flat UI Objects around anywhere in the Worksheet once configured
  • Two styles of Checkbox indicator are available, a Square and a Tick
  • Capture the output of any interaction with the Flat UI Objects
  • Lots of examples including my Dark Black & Grey theme - see the image below
  • When using the Popup Button, run a Macro to change the background Fill of the ActiveSheet or Flash the Excel Window
  • Change the Colours and Formatting of the individual Shapes
  • On 07/05/2022 I did a retro-fit of my Advanced Slider Code for the Sliders in this Project, allowing quick setup, manual position setting and the use of a dynamic Range ie. 1|5 for positions 1 to 5. Numeric and percentage (%) Cell formats are now automatically picked up by the Code, just change the Cell format. Please note: the Slider object Shapes are no longer Grouped
  • On 14/05/2022 I did a Retro-fit of my Specialist Horizontal Step Slider for additional Step Sliders in this Project. The Step Slider will spring to the closest Step in the Range, can be set manually and allows for extensibility through the various Named Ranges. You can tweak the Cursor Drag and Speed Coefficients to change how the Slider Button feels and acts
  • Version 1.5 introduces my latest Flat UI Sliders using Awesome Slider Code. Slider Buttons that can be Dragged by the Mouse Horizontally or Vertically to Adjust a Value on a Scale within a Range










Installation

FlatUI.xlsm is ready to use (version specific naming of the file may differ with each new release). Open the FlatUI.xlsm File and test out the UI on the Example1, Example2 and Example3 Sheets. Take a note of how the Objects move and update the Defined Names (Named Ranges). In order to select any of the Shapes or Graphic Objects you must first Unprotect the Sheet. Please read all of the info on the individual Sheets and in this online documentation before you begin to edit and use the Objects in your own Projects or before turning to Support

Usage

How to use Flat UI


Example1 Sheet
On this Sheet you will find all of the Flat UI that does not use any extended Shapes ie. Textboxes. The Flat UI are, Slider, Checkbox, Togglebutton, Radiobutton, Push Button and Popup Button. In order to select any of the Shapes or Graphic Objects you must first Unprotect the Sheet so do that. Now, use the Selection Pane on the Editing Group of the Home Tab of the Ribbon to make Selections easier (right-click on any Shape first). Let's work through the Flat UI Objects on this Sheet. We will look at the Slider first

Slider (New Advanced Slider Code for 2022)

On 07/05/2022 I did a retro-fit of my Advanced Slider Code for the Sliders in this Project, allowing quick setup, manual position setting and the use of a dynamic Range ie. 1|5 for positions 1 to 5. Numeric and percentage (%) Cell formats are now automatically picked up by the Code, just change the Cell format. Please note: the Slider object Shapes are no longer Grouped. The Slider allows you to slide or move a Button back and forth along a bar and manually set an increase/decrease for some value or percentage. This UI Object will output a value by default as 0 through to 100. To use a Range ie. 50 through to 100 you would include a pipe-delimited string like this 50|100 in the Cell with the Named Range SLider1Range. Whenever the Slider Button is moved the value will be output to the Defined Name 'Slider1'. The Shapes can be seen below on the Selection Pane on the RHS. The Shape naming conventions are, 'UI_Slider1', 'Slider1', 'Slider1Bar' and 'Slider1Placeholder'. Right-click any Selected Shape and choose 'Format Shape' to change any of the formatting. This Flat UI Object does not use the Alt. Text member of any of the Shapes. To see how the Macro is linked, select the 'Slider1' Shape and hover near it. Right-click and choose 'Assign macro' to view the Macro 'Slider'. Click Edit to go into the Code. Please Note: the 'Slider1' Shape is the only Shape that you need to link to a Macro



Important! to Copy this Slider into your own Project, open your Project and the FlatUI.xlsm file - your project should also be a Macro-enabled file. Now select the 3 Shapes, 'Slider1', 'Slider1Bar' and 'Slider1Placeholder' and Copy to the Clipboard (use CTRL+Left Mouse Click to select each one). Switch to your own Project and Paste the Slider Shapes. Add a Named Range to your Project ie. Slider1. Go into the Code. Drag the 'mdAdvancedSlider' Code Module into your own Project and then link up the 'Slider1' Shape to the 'Slider' Macro(). To enable the manual position setting add the Code from the Example Code Module into your own Project and change the Cell Address being picked up to the Cell where you are editing the Cell position. That's it, now either set the Slider position manually or drag the Slider to update the value. Add a Named Range Slider1Range and 1|5 to force the Slider to use the Range 1 through to 5 for its positions

Checkbox

The Checkbox allows you to toggle a setting or option by toggling a tiny box On or Off. From version 1.1 there are now two styles of Checkbox indicator, a 'Square' and a 'Tick' - see the Screen shots and read the Changelog for more information. The output will be to the Defined Name 'Checkbox1' and will be TRUE or FALSE. The Shapes can be seen below on the Selection Pane on the RHS. The Shape naming conventions are, 'UI_Checkbox1', 'Checkbox1' and 'Checkbox1Checked'. Right-click any Selected Shape and choose 'Format Shape' to change any of the formatting. This Flat UI Object does not use the Alt. Text member of any of the Shapes. To see how the Macro is linked, select the 'Checkbox1' Shape and hover near it. Right-click and choose 'Assign macro' to view the Macro 'Checkbox'. Click Edit to go into the Code. Please Note: the 'Checkbox1' Shape is the only Shape that you need to link to a Macro. There are 2 versions of the Checkbox available on the Example1 Sheet. One with a light grey center and one with a blue center "UI_Checkbox2". Notice my naming convention for repeated Objects, always increment your main UI Object and also the Shapes within the sets to ensure that there are never any duplicates!



Important! to Copy this Checkbox into your own Project, open your Project and the FlatUI.xlsm file - your project should also be a Macro-enabled file. Now select the 'UI_Checkbox1' Object and Copy to the Clipboard. Switch to your own Project and Paste the Checkbox. Add a Defined Name to your Project ie. 'Checkbox1'. Go into the Code. Drag the 'mdCheckbox' Code Module into your own Project and then link up the 'Checkbox1' Shape to the 'Checkbox' Macro(). That's it, now press the Checkbox to toggle the value between TRUE and FALSE

Toggle Button

The Toggle Button allows you to toggle a setting or option by clicking a tiny Button on a Cylinder back and forth. You can click either the tiny Button or the Cylinder itself. The output will be to the Defined Name 'ToggleButton1' and will be TRUE or FALSE. The Shapes can be seen below on the Selection Pane on the RHS. The Shape naming conventions are, 'UI_Toggle1', 'ToggleIcon1', 'Togglebutton1' and 'ToggleCylinder1'. Right-click any Selected Shape and choose 'Format Shape' to change any of the formatting. This Flat UI Object uses the Alt. Text member to hold information on the next Button direction and the Icon colour before and after it is toggled. These settings must be maintained otherwise the Code will error. The Alt. Text for a Shape can be found on the 'Accessibility' Group of the 'Shape Format' Tab on the Ribbon. You should not edit the Button direction Alt. Text however if you want, you can change the Icon colour by pasting in a Long colour ie. 12566463 (light Grey). This Flat UI element requires you to link at least the Icon and Button to a Macro, but in my examples I have also linked the Cylinder Shape to the Macro so that it is toggled whenever you click on any of the Shapes. To see how the Macro is linked, select the 'ToggleIcon1' Shape and hover near it. Right-click and choose 'Assign macro' to view the Macro 'Toggle'. Click Edit to go into the Code. There are 2 versions of the Toggle Button available on the Example1 Sheet. One with a light grey center and one with a blue center "UI_Toggle2". Notice my naming convention for repeated Objects, always increment your main UI Object and also the Shapes within the sets to ensure that there are never any duplicates!



Important! to Copy this Toggle Button into your own Project, open your Project and the FlatUI.xlsm file - your project should also be a Macro-enabled file. Now select the 'UI_Toggle1' Object and Copy to the Clipboard. Switch to your own Project and Paste the Toggle Button. Add a Defined Name to your Project ie. 'Togglebutton1'. Go into the Code. Drag the 'mdToggle' Code Module into your own Project and then link up the 3 Shapes, 'ToggleIcon1', 'Togglebutton1' and 'ToggleCylinder1' to the 'Toggle' Macro(). That's it, now press the Toggle Button to toggle the value between TRUE and FALSE

Radiobutton

The Radiobutton allows you to select a single Button from a list of Buttons ie. an option within a set of choices. You click one of the tiny Radiobuttons to switch the option On/Off. The output will be to the Defined Name of the Radiobutton that you selected ie. 'ARadiobutton1' and will be TRUE or FALSE - notice the naming convention use of the letter A, which indicates the Radiobutton Group. A further output is the Index of the Radiobutton selection ie. 1 for the first Radiobutton, 2 for the second Radiobutton etc. The Index is output to a Defined Named of 'UI_Radiobutton1'. The Shapes can be seen below on the Selection Pane on the RHS. The Shape naming conventions are, 'UI_Radiobutton1', 'ARadiobutton1' and 'ARadiobutton1Checked' for the Radiobutton and the first Radiobutton in the Group. Right-click any Selected Shape and choose 'Format Shape' to change any of the formatting. This Flat UI Object uses the Alt. Text member to hold information on the Index as it is selected. This setting must be maintained otherwise the Code will error and you should add the Index of the Radiobutton within the Group to the Alt. Text whenever you add another Radiobutton to the Group. The Alt. Text for a Shape can be found on the 'Accessibility' Group of the 'Shape Format' Tab on the Ribbon. This Flat UI element requires you to link only the individual Radiobuttons that make up the Group ie. 'ARadiobutton1', 'ARadiobutton2' etc. to a Macro. To see how the Macro is linked, select the 'ARadiobutton1' Shape and hover near it. Right-click and choose 'Assign macro' to view the Macro 'Radiobutton'. Click Edit to go into the Code. There are 2 versions of the Radiobutton available on the Example1 Sheet. One with a light grey circle center and one with a blue circle center "UI_Radiobutton2". Notice my naming convention for repeated Objects, always increment your main UI Object and also the Shapes within the sets to ensure that there are never any duplicates!



Important! to Copy this Radiobutton Group into your own Project, open your Project and the FlatUI.xlsm file - your project should also be a Macro-enabled file. Now select the 'UI_Radiobutton1' Object and Copy to the Clipboard. Switch to your own Project and Paste the Radiobutton Group. Add 4 Defined Names to your Project ie. 'UI_Radiobutton1', 'ARadiobutton1', 'ARadiobutton2' and 'ARadiobutton3'. Go into the Code. Drag the 'mdRadiobutton' Code Module into your own Project and then link up the 3 Shapes, 'ARadiobutton1', 'ARadiobutton2' and 'ARadiobutton3' to the 'Radiobutton' Macro(). That's it, now press any of the Radiobuttons to make a selection and update the Index and individual Button value between TRUE and FALSE

Push Button

The Push Button allows you toggle between On/Off (remember this is Flat UI so a 3D effect here is not required). To ascertain On from Off, the colour of the Icon changes from Light Grey to Blue. The output will be to the Defined Name of 'Button1' and will be TRUE or FALSE. The Shapes can be seen below on the Selection Pane on the RHS. The Shape naming conventions are, 'UI_PushButton1', 'OffIcon1', 'OffButton1', 'OnIcon1' and 'OnButton1'. Right-click any Selected Shape and choose 'Format Shape' to change any of the formatting. This Flat UI Object uses the Alt. Text member to store the Button Name ie. 'Button1' for all of the Shapes except the main Grouped Shape. This setting must be maintained otherwise the Code will error and you should change the Button Name to consecutive numbering whenever you Copy the Flat UI Object. The Alt. Text for a Shape can be found on the 'Accessibility' Group of the 'Shape Format' Tab on the Ribbon. This Flat UI element requires you to link all of the individual Icon and Button Shapes that make up the Group to a Macro. To see how the Macro is linked, select the 'OffIcon1' Shape and hover near it. Right-click and choose 'Assign macro' to view the Macro 'Push'. Click Edit to go into the Code



Important! to Copy this Push Button into your own Project, open your Project and the FlatUI.xlsm file - your project should also be a Macro-enabled file. Now select the 'UI_PushButton1' Object and Copy to the Clipboard. Switch to your own Project and Paste the Push Button. Add a Defined Name to your Project called 'Button1'. Go into the Code. Drag the 'mdButtons' Code Module into your own Project and then link up all of Shapes, 'OffIcon1', 'OffButton1', 'OnIcon1' and 'OnButton1' to the 'Push' Macro(). That's it, now press and depress the Push Button to toggle the setting to TRUE or FALSE

Popup Button

The Popup Button allows you press and hold a Button to run a Macro before springing back up, hence the Name 'Popup'. Two Popup Buttons are shown on the Example1 Sheet. As you press the first Button the Icon changes colour from Light Grey to Blue and a flash is made that changes the background Fill of the Sheet to a slightly darker colour and then back again to the standard Fill colour to indicate the press. Upon releasing the Mouse Button then the Macro assigned to the Shapes will run. There is no output to any Defined Names as this Flat UI requires some subtle naming convention via the Shapes to allow Macros to automate. Icon changes from Light Grey to Blue. The output will be to the Defined Name of 'Button1' and will be TRUE or FALSE. The Shapes can be seen below on the Selection Pane on the RHS. The Shape naming conventions are, 'UI_PopupButton1', 'Macro1_OffIcon2', 'Macro1_OffButton2', 'Macro1_OnIcon2' and 'Macro1_OnButton2' - notice the use of the consecutive naming of the 'OffIcon2' and 'OffButton2'. Now one other feature of this Flat UI Object is the ability to run a Macro. The Macro Name must be passed as a prefix with a '_' underscore used as a delimiter/terminator in all of the Shape Names. This Macro should be a unique Name in your Code adn should be stored in a standard Code Module - I add my Macros in the 'mdButtons' Code Module. Right-click any Selected Shape and choose 'Format Shape' to change any of the formatting. This Flat UI Object uses the Alt. Text member to store the Button Name ie. 'Button1' for all of the Shapes except the main Grouped Shape. This setting must be maintained otherwise the Code will error and you should change the Button Name to consecutive numbering whenever you Copy the Flat UI Object. The Alt. Text for a Shape can be found on the 'Accessibility' Group of the 'Shape Format' Tab on the Ribbon. This Flat UI element requires you to link all of the individual Icon and Button Shapes that make up the Group to a Macro. To see how the Macro is linked, select the 'OffIcon1' Shape and hover near it. Right-click and choose 'Assign macro' to view the Macro 'Push'. Click Edit to go into the Code



The second Popup Button is linked to a routine that flashes the Excel Window instead of changing the background Fill colour of the Sheet. It is called 'UI_PopupButton2' and all of the rules given above for 'UI_PopupButton1' apply to this Flat UI Object as well

Important! to Copy these Popup Buttons into your own Project, open your Project and the FlatUI.xlsm file - your project should also be a Macro-enabled file. Now select the 'UI_PopupButton1' Object and Copy to the Clipboard. Switch to your own Project and Paste the Popup Button. Go into the Code. Drag the 'mdButtons' Code Module into your own Project and then link up all of Shapes, 'Macro1_OffIcon1', 'Macro1_OffButton1', 'Macro1_OnIcon1' and 'Macro1_OnButton1' to the 'Popup' Macro(). That's it, now press and depress the Popup Button to flash the Excel Window and then run the 'Macro1' Subroutine in the Code

Example2 Sheet
This Sheet contains 2 Grouped Objects, a Radiobutton Textbox and a Checkbox Textbox. These Flat UI Objects have been designed with extended Text Properties, meaning that the Options are Text Boxes that sit alongside the standard Flat UI Objects allowing you to click either the individual Radiobuttons or Checkboxes, or click the Option Text to toggle the setting for the Defined Name between TRUE and FALSE. They all have the same Defined Names as the standard Flat UI Objects. There are some noticable differences though. We now have another set of Shapes called 'AOption1Checked', 'AOption2Checked' and 'AOption3Checked'. The Alt. Text for each of these Shapes must include the Option number ie. 1, 2 and 3 respectively. This is used by the Code to ascertain which Text Shape was clicked. Another subtle difference is that this Flat UI Object is linked also by the Textbox Shapes 'AOption1Checked', 'AOption2Checked' and 'AOption3Checked' to the Macro 'RadiobuttonTextbox' in stead of 'Radiobutton' and you need to link all of these additional Textbox Objects to that Macro. Copying this Flat UI Object into your own Project is similar to the process outlined above for the standard Radiobutton Flat UI Object. Here is the Radiobutton Textbox with the additional Textbox Shape selected:



The Checkbox Textbox Flat UI Object is similar to the standard Flat UI Object however it also has extended Textbox Properties. It has an additional Textbox Shape added with the name 'Option1'. The Alt. Text must have an Index ie, for Option1 it would be 1, for Option2 it would be 2. Again, this is used by the Code to indicate that the Textbox was clicked instead of the Checkbox itself. The Macro that is linked to this Flat UI Object for the 'Option1' Shape is called 'CheckboxTextbox' in the 'mdButtons' Code Module. Here is the Checkbox Textbox:



Example3 Sheet
This Sheet is the same as Example1 Sheet but all of the Flat UI Objects have been restyled slightly in a Carbon/Grey theme. It also features an additional Toggle Button, This is what Sheet3 looks like:



Example4 Sheet
This Sheet demonstrates Sliders that use my latest Awesome Sliders Code to give much more realistic look and feel as you drag the Slider Button around

XXXX

More Info - Editing the Shapes (Selections and Formatting Panes)
In order to select any of the Shapes or Graphic Objects you must first Unprotect the Sheets as Code protection is added every time that they are used to protect the interface (protects the Shapes from user interference, either on purpose or accidently) - do this from the Review Tab on the Ribbon. Click the Example1 Sheet. Right-click one of the Slider Buttons or left-click the Bar. Now, use the Selection Pane on the Editing Group of the Home Tab of the Ribbon to make Selections easier. To format a Shape you can hover near the Selection and use right-click Format and then change the formatting using the formatting Pane. I like to toggle on a Shape between the Format Pane, Selection Pane and Alt. Text

More Info - SVG Icons
The Icon Buttons use an SVG Icon. To change the Icon, you first need to Unprotect the Worksheet. Then right-click the Graphic Object or the Icon Shape and use the Selection Pane on the Editing Group of the Home Tab of the Ribbon. Now choose, change Graphic, from Icons on the Change Group of the Graphics Format Tab on the Ribbon and pick another Icon

More Info - Tips
Resizing the Grouped Flat UI Objects to create larger/smaller ones:
Unprotect the Worksheet and select one of the Grouped Button Shapes. Hold down Shift and then drag the object to resize it. Please note: for the Slider Object, you will have to tweak the positioning of any Bars and Placeholders and/or use the Align Shape on the Arrange Group of either the Graphic Format or Shape Format Tab on the Ribbon. You may also have to adjust the Code to take account of your changes

Moving Objects:
You have a couple of options. Firstly Unprotect the Sheet and then click on the Grouped Shape - drag this anywhere in the Sheet. Secondly select a larger area of Cells that surround the Flat UI Objects and then drag the Cell Range to another location in the Sheet

Flat UI

Example 1 - the default Flat UI Objects

Example 2 - the Flat UI Objects with extended Textbox Properties, meaning you can click anywhere on the Text that accompanies the Radiobuttons and Checkboxes to toggle them

Example 3 - my Carbon & Grey theme with an extra Toggle Button because I liked the alternative styling

Example 4 - Sliders using Code from my latest Project Awesome Sliders

FAQ

Q. Can I use a Tick for the Checkbox?
A. Yes, version 1.1 now includes a Tick indicator for the Flat UI Checkbox as well as the Square indicator. The Tick indicator is simply a Tick Icon inserted into the Shape used for the Square indicators - there is no change to the Code or Grouping and these Checkboxes can standalone or be Grouped as you like. You can also 'stack' these little bad-boys just like the Checkbox Textboxes and use Text Options to toggle the Defined Name values On/Off as TRUE/FALSE. Just Copy the Grouped, Flat UI Shapes as you would the others

Q. When I Copy a Toggle Flat UI Object and link it up to my Macro, the animation or easing appears to stop working, why? And, how can I fix this?
A. Adding a Toggle Flat UI to a Project and linking it to your Macro may result in the easing 'appearing' to stop working, but it hasn't, you may just need to give Excel a little more processing time back. Add a DoEvents line to the Code, either in the Easing Subroutine or between the 'Button.left = easeOutQuintic(TweenTime, ButtonMoveFrom, ButtonMoveTo - ButtonMoveFrom, 1)' and the 'Icon.left = easeOutQuintic(TweenTime, IconMoveFrom, IconMoveTo - IconMoveFrom, 1)/ lines in the Code. Also try changing the 'timer refresh rate ie. 40 per second, 1 / 40 = 0.025' to 80


Flat UI Example Sheets 1-3

This is a video of the Flat UI Objects in action. In this demonstration, I go through each of the Objects, toggling the options. I also select the Toggle and show you how to assign the Macro 'Toggle()'. Music Evil Empire (Original Mix) by Tycoos Get it Here · view this Flat UI video on YouTube

Flat UI Example Sheet 4

This is a video of the Flat UI Slider Objects in action using my latest Awesome Sliders Code. Music Evil Empire (Original Mix) by Tycoos Get it Here

Support

Support is 100% optional and I provide it for your convenience, so please be patient, polite and respectful

Support for my Software

  • Responding to questions or problems regarding the Software and its features
  • Fixing valid (replicated) bugs and reported issues for the VERSION I HAVE WRITTEN

Software support does not include

  • Customization and installation services
  • Support for third party software or ANY kind of development whatsoever

Before seeking support

  • Make sure your question is a valid Software Issue and not a customization request
  • Make sure you have read through the FAQ's, online documentation and any related video guides before asking support on how to accomplish a task
  • Ensure that you access to the VBOM is allowed and that Macros can run in Excel
  • Make sure to provide 'proof of purchase' and state the name / version of the Software that you are having issues with when requesting support by Email or via Facebook

How to get Support

Contact Mark Kubiszyn on the Email address provided when you purchased the Software, including the Order Number
Remember to be patient, if there has been an issue with your download, Mark will always respond within 48 hours and will Email you the File directly if neccessary. For other issues the response time may be considerably longer and I may choose to respond to specific questions only (as is my right), depending on what has been asked

Future Builds

* No ideas as yet!

Bug Fixes

* There are currently no bugs identified for Flat UI

Changelog

Read more information on the status of each release below. The latest Version including a description of any changes is shown first

16.09.2022 - (Version 1.5)

Added my latest Flat UI Sliders using Awesome Slider Code as a new Sheet entitled 'Example4'

14.05.2021 - (Version 1.4)

Retro-fit of my Specialist Step Slider which adds Extensibility to the Flat UI Slider in this Project. The Step Slider will spring to the closest Step in the Range, can be set manually and allows for extensibility through the various Named Ranges. You can tweak the Cursor Drag and Speed Coefficients to change how the Slider Button feels and acts

07.05.2021 - (Version 1.3)

Retro-fit of my Advanced Slider Code for the Sliders allowing quick setup, manual position setting and the use of a dynamic Range ie. 1|5 for positions 1 to 5. Numeric and percentage (%) Cell formats are now automatically picked up by the Code, just change the Cell format. Please note: the Slider object Shapes are no longer Grouped

10.07.2021 - (Version 1.1 and Version 1.2)

The introduction of a Tick indicator for the Flat UI Checkbox as well as a Square indicator. The Tick indicator is simply a Tick Icon inserted into the Shape used for the Square indicators - there is no change to the Code or Grouping and these Checkboxes can standalone or be Grouped as you like. You can also 'stack' these little bad-boys just like the Checkbox Textboxes and use Text Options to toggle the Defined Name values On/Off as TRUE/FALSE. Just Copy the Grouped, Flat UI Shapes as you would the others

08.07.2021 - (Version 1)

General Release