Introduction

Turbo

Self-contained, ultra-fast, silky-smooth White Lightbox and CSS Spinner Class for Excel & Access 2013/2016 (32bit & 64bit)

Turbo features 2 dynamically created UserForm overlays (Lightbox and a Spinner) and a dynamically created WebBrowser that perform a Fade in/out for both the Lightbox and the Spinner. The nice thing about this Code is that it is self-contained within a single Class Module, meaning it is lightweight and can easily be incorpurated into Projects with just 3 Calls to Init(), Go() and Kill() with lots of configurable Parameters

Prerequisites

  • Excel & Access 2013-2019, preferrably Version 16.0
  • Basic Excel skills. Basic to moderate VBA Skills
  • Windows PC · NOT a Mac!

Features

  • 3 Calls, Init(), Go() and Kill()
  • Quick, smooth configurable animation
  • A single Class Code Module - all UserForms and WebBrowser Objects are dynamically created at run-time
  • Pre-initialse Turbo for an instant start when opening Excel for the first time
  • Beautiful fade for the Lightbox and the CSS Spinner
  • Add your own Base64 encoed animated Gif to the Code if you so wish
  • Configurable Spinner using CSS and JavaScript, built around the Code featured here by Stephan Wagner
  • Excel & Access Examples included in the Zip File

Installation

Turbo_v1.zip contains the Files. Right-click, Extract All, to unzip the Files. Read the License.txt File. Open the Workbook and test the Demos. An Access Example is also included if you want to use Turbo with Microsoft Access. To view the Code behind the Turbo Demos, click 'View Code' (you will need to enable Macros)

Usage

VBA

  • Turbo.Init will initialise the Lightbox and CSS Spinner
  • Turbo.Go will run the Lightbox and CSS Spinner animations
  • Your Task goes here...

  • Turbo.Kill will terminate the Lightbox and CSS Spinner

Turbo has lots of 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):

  • Turbo.Init
    LightboxOpacity:=140
    LightboxColour:=White
    SpinnerWidth:=48
    SpinnerHeight:=48
    SpinnerThickness:=5
    SpinnerBackgroundColour:=Grey
    SpinnerTopColour:=Black
    SpinnerBottomColour:=Blue
    SpinnerEasing:=Linear
    SpinnerSpeed:=0.6
    SpinnerFadeInOutSpeed:=2#
    SpinnerFadeInDelayDuration:=200
    SpinnerFadeOutDelayDuration:=1400

  • Turbo.Go
    LightboxFadeInSpeed:=0.03
    LightboxFadeInStep:=25.5

  • Turbo.Kill
    Timeout:=0.02
    LightboxFadeOutSpeed:=0.03
    LightboxFadeOutStep:=17

FAQ

There are currently no frequently asked questions about Turbo

Screen Shots

A Lightbox and Blue/Black Ring CSS Spinner using Ease Out running a Task

A Lightbox and Black Ring CSS Spinner using Linear Easing running a Task

A Turbo Access Example of a Lightbox and a Blue & Black Ring CSS Spinner

A Turbo Access Example of a Lightbox and a Black Ring CSS Spinner

Video

Here I run the Demos that ship with the Turbo Software

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

01.11.2019, (Version 1) release. 08.01.2021 added an Access example of usage for Access version 16.0