Introduction

Statusbar Thread

Configurable Statusbar Spinner & Lightbox Class for Excel 2013 & 2016 (32bit or 64bit)

A Lightbox is a Light or Dark overlay that covers the entire Application Window. My Lightbox Class features some abstraction, based around a Class example by Rubberduck whereby you do not neccesarily need to ever Unload a UserForm in order for it to go out of Scope. The UserForm implements an IFoo Class and IWrapper Class to pass the UserForm as an Object. The Spinner Class is a further extention of this philosophy. Combined the Software writes out a configurable CSS Spinner to the Statusbar or the Screen Center, used while running a task. In this Software the Thread is the 'Spinner' that will appear

Prerequisites

  • Excel 2013-2016, (32bit & 64bit)
  • Basic Excel skills. Basic to moderate VBA Skills
  • Windows PC · NOT a Mac!

Features

  • 3 Calls, Init(), Go() and Kill()
  • Quick, smooth configurable Lightbox overlay effect
  • Change the Colour and Opacity of the Lightbox from 0-255
  • Change the Spinner Easing Type, Colours, Thickness, Speed and Position

Installation

Statusbar_Thread_v1.XLSM is ready to use. Open the Workbook and test the Demos. To view the Code behind the Lightbox Demos, click 'View Code' (you will need to enable Macros). It is encouraged that you build you Project around Statusbar Thread, however, merely copy in the UserForms and Class Code Modules in the Explorer Window to your Project and wrap an example around your task

Usage

VBA

  • Thread.Init will initialise the Thread
  • Thread.Go will run the Thread animation
  • Your Task goes here...

  • Thread.Kill will terminate the Thread

Thread has some configurable Class Members (Any Thread/Spinner settings ie. Speed or Easing must be made prior to an Init() Call):

  • Thread.SpinnerSpeed = 0.4
  • Thread.SpinnerEasing = ease
  • Thread.SpinnerTopColour = Red
  • Thread.SpinnerBottomColour = Black
  • Thread.SpinnerThickness = 1
  • Thread.SpinnerPosition = StatusBar
  • Thread.SpinnerWidth = 64
  • Thread.SpinnerHeight = 64

Lightbox has some configurable Class Members (Any Lightbox settings ie. Colour and Opacity must be made prior to a Go() Call):

  • Lightbox.LightboxColour = vbWhite
  • Lightbox.LightboxOpacity = 100

More Information

Please Note: these Parameters are not passed in the 3 Subroutine Calls. For the SpinnerSpeed member you can use any values like 0.6, 0.8, 1.2 etc. For the SpinnerEasing you can use 1 of 5 Easing Types, linear, ease, ease_in, ease_out and ease_in_out. Further Easing is allowed but not within the scope of this article. For the SpinnerTopColour and SPinnerBottomColour members, you can use any ColourType, ie. Green, Orange, Black, Gold, Blue, Red and Grey or a long value. For the SpinnerThickness you can use small numbers like 1, 2, 3. For the SpinnerPosition you can use StatusBar or ScreenCenter. For the SpinnerWidth and SpinnerHeight you can use 8+. For the LightboxColour member you can use vbWhite, vbBlack, RGB(255, 255, 255 or a long value, 5324346. The LightboxOpacity member can be 0-255 with 0 being totally transparent and 255 being a Solid Fill

FAQ

There are currently no frequently asked questions about Statusbar Thread

Screen Shots

A Lightbox featuring a light overlay with a Spinner using the default easing displayed upon the Statusbar

A Lightbox featuring a light overlay with a large Orange and Green Spinner centered on the Screen

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

20.10.2019, (Version 1) release