Lightbox

Introducing Lightbox - 3 different methods to Creating a Lightbox (with easing) and an Access example

An Abstract Class demonstrating a configurable Lightbox Overlay, a minified dynamic UserForm Class and a single Lightbox UserForm Class for Excel 2013 & 2016 Version 16.0 (32bit or 64bit) designed for Windows 11

Lightbox v1
A Lightbox is a Light or Dark overlay that covers the entire Application Window. Version 1, 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. Retro-fit for Windows 11 fix for rounded corners & resized Windows

Lightbox v2
Lightbox version 2, consists of just 3 minified Classes that create a dynamic Borderless UserForm with easing and Transparency. It will instantiate a UserForm with the following Methods: Show(), TransitionIn() and TransitionOut(). It allows proprietary access (without intellisense) to Properties such as Width, Height, StartUpPosition via the PseudoInterface Property of the Foobar Class. It then uses the Transition Methods to Fade the Lightbox overlay in and out on a Timer together with easing Functions. Retro-fit for Windows 11 fix for rounded corners & resized Windows

Lightbox v3
Lightbox version 3 is a single UserForm Code Module that encapsulates most of the Code for version 2 but it doesn't create a dynamic UserForm for the Lightbox, it is, in essence the Lightbox itself. It is a lot more easier to implement and understand. Simply drag the Code Module across to your Project and you are good to go! This version still allows easing and has the advanced Timer functionality of version 2. This is also the version that is used for the Access example included in the download. Retro-fit for Windows 11 fix for rounded corners & resized Windows

Warning!  Videos may contain explicit lyrics, listen at your own risk!

Prerequisites

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

Online Documentation/Help/Features/Credits:

https://www.kubiszyn.co.uk/documentation/lightbox.html

Please note: this Software is released under an MIT license and as such you must attribute the author, Mark Kubiszyn whenever distributing or remixing the work