Spinner

Purchase · £2.99

Introduction

Spinner

Configurable CSS Preloaders with a lightbox for Excel 2013 & 2016 (32bit or 64bit)

Spinners are configurable HTML/CSS animations with a Lightbox overlay, designed to be displayed whilst running a Task in Excel. Spinner has 3 Calls, Init(), Go() and Kill() with some Named Arguments for each that set the Spinner Size, alternative Colours and/or Thickness for the animations

Prerequisites

  • Excel 2016/2019, Version 16.0 (64bit only!)
  • Basic Excel skills. Basic to moderate VBA Skills
  • Windows PC · NOT a Mac!

Features

  • 3 Calls, Init(), Go() and Kill()
  • Quick, smooth configurable animation
  • Place the Animation ontop of the Lightbox or behind the Lightbox
  • Change the Size of the Spinners and some of the Colours or Thickness

Installation

Spinner_v1.3.XLSM is ready to use. Open the Workbook and test the Demos. To view the Code behind the Spinner Demos, click 'View Code' (you will need to enable Macros)

Usage

VBA

  • Spinner.Init will initialise the Spinner
  • Spinner.Go will run the Spinner animation

    • Your Task goes here...

  • Spinner.Kill will terminate the Spinner

Spinner has some configurable Optional Parameters. Here are some of the allowed Optional Named Arguments for each Call (you can play around with these to tweak the Spinner animation type, colour, thickness and the Lightbox colour):

  • Spinner.Init SpinnerType:=Circles, Scaler:=0.8, Colour:=ChathamsBlue, Thickness:=16, LightboxColour:=Blackish
  • Spinner.Go WindowPosition:=Top
  • Spinner.Kill Timeout:=0.04

More Information

For the Spinner.Init() Call, you can Pick from 5 different Spinner Types, Circles, Ring, Donut, Square and Pulse. The Scaler Named Arguement allows you to resize the Spinner ie. 0.5 is 50% of the original Size, 1.5 will be 1 and a half times the original Size. The Colour Named Arguement can be an RGB or a Long Value for a Colour or one of the ColourType Enumerations (not all of the Spinners Colours can be changed). The Thickness Named Arguement controls the Width or Thickness of the main Animation (not all of the Spinners Thickness can be changed). The LightboxColour Named Arguement sets the Lightbox overlay Colour - typically this is White or Black but it can be any RGB, Long Value or Colour Enumeration. The Timeout Named Arguement allows a slight pause if required before the Spinner is completely removed from the Screen

FAQ

There are currently no frequently asked questions about Spinner

Video

Here I run the Demos that ship with the Spinner Software. CSS Animations have been ported from CodePen and integrated into Markup for the WebBrowser Control (all Authors are credited in the Markup VBA Code)

Support

Please remember you have purchased very affordable Software and you have not paid for a full-time Software design agency - I am but one man. Occasionally I may help with small tweaks, but these requests will be put on a much lower priority due to their nature. You have not PAID for Support, Support is 100% optional and I provide it for your convenience, so please be patient, polite and respectful

Support (limited) for my Software includes

  • 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
...or Contact Mark Kubiszyn via our Facebook Page - 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 or via Messenger. 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

Changelog

You can find the version history in the Code Module for any Macro-enabled Software or read more information on the status of each release
- the latest Version including a description of any changes made is always shown first

27.10.2019 - (Version 1.3) 
Added a Microsoft Spinner animation
25.10.2019 - (Version 1.2) 
Bug when initialising the Spinner using Workbook_Open()
- InitialiseAnimation variable was set to True and Init() would not run on first run of an animation as the Spinner was deemed to be already running
Adding the Call to Spinner.Kill() fixes the problem and unloads the UserForms.  system is still in a ready state for the first time it is called thereafter to be processed

18.10.2019 - (Version 1.1) 
Fix for the centering of the large circles if the user 'glues' the Workbook to the top and bottom of the screen Height by manually moving the Excel Window
14.10.2019, (Version 1), release