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 SpinnerTurbo.Go
will run the Lightbox and CSS Spinner animationsTurbo.Kill
will terminate the Lightbox and CSS Spinner
Your Task goes here...
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