Introduction

UserForms for Excel Developers

Lightbox UserForm

This UserForm is a ready-made Lightbox that uses Easing to control its animations in and out. You get a single UserForm and some Code instructions. Simply import the UserForm, add some Code and away you go. You are purchasing version 1.1 featuring the Windows 11 fix for rounded and resized Windows

Prerequisites

Excel Version 16.0
Basic to moderate Excel Skills and VBA skills to import the UserForm Code Module and then add some example Subroutines
Windows PC · NOT a Mac!
No support is provided for customization of this Software

Features

a single UserForm
24 easing Functions

easeBackInCubic
easeBackInQuartic
easeInBack
easeInCirc
easeInCubic
easeInExpo
easeInOutCubic
easeInOutQuintic
easeInQuad
easeInQuadratic
easeInQuart
easeInQuartic
easeInQuintic
easeInSine
easeLinear
easeOutBack
easeOutBounce
easeOutElastic
easeOutInCubic
easeOutInQuartic
easeOutQuad
easeOutQuartic
easeOutQuintic
easeOutSine

Installation

Lightbox-UserForm.zip contains all of the Files. Unzip the Archive to your PC (right-click, extract all...). There are 4 Files, the Lightbox.frm File, the Lightbox.frx File (the 2 main Lightbox UserForm Code Module parts), a Readme.txt File and a License.txt File. Open and read the two text Files. The Readme.txt File includes the example Code needed to demonstrate the Lightbox

Usage

Using the Class

Import the UserForm
In order to use the Lightbox UserForm you will need to import it into Excel. Open your Project or a new Excel Workbook. Open the VBE Editor and do File->Import File, browse and search for the Lightbox.frm File that you unzipped and then load it in. Open the Readme.txt File that you unzipped and add the Code examples in this File into any Code Module - if you do not have a Code Module insert one into your new or existing Project first and then add the Code example from the Readme.txt File. Now you are good to go. Run the Code examples. A simple illustration of using the Code is shown below:

' -¬ Lightbox Example
Public Sub White_Lightbox_EaseOutSine()
   
   Lightbox.FadeIn False, FitToExcel, easeOutSine
   DummyTask 1200
   Lightbox.FadeOut easeOutSine

End Sub

'-¬ DummyTask, runs a dummy task
Private Sub DummyTask(ByVal TaskLength As Long)
   Dim Start As Date
   Dim Running As Long
   '@Ignore DefaultMemberRequired
   Start = Now()
   For Running = 1 To TaskLength
      '@Ignore DefaultMemberRequired
      Application.StatusBar = "Running a dummy task: " & Running & " Elapsed Time: " & Format$(Now() - Start, "ss")
      DoEvents
   Next Running
   Application.StatusBar = Empty
   Running = 0
   Start = 0
End Sub

Lightbox UserForm for Excel

The LightBox UserForm Code Module Screen Shot (not much to look at but then it is a Lightbox Overlay and the effect is made on the default UserForm when the Code is ran)

The VBA in the Lightbox Code Module Screen Shot

The Dark, Lightbox Effect Screen Shot

The Light, Lightbox Effect Screen Shot

FAQ

There are no Q & A for Lightbox UserForm

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

Future Builds

* Nothing to show here yet!

Bug Fixes

* There are currently no bugs identified

Changelog

Read more information on the status of each release below. The latest Version including a description of any changes is shown first


18.12.2021 - (Version 1.1)

Fix for Windows 11 OS, for a Lightbox. The code detects the the OS Build Number >=22000 indicating Windows 11 or greater and then rounds the Window corners and adjusts the Windows Width & Height


04.10.2021 - (Version 1) Released

General release of Lightbox UserForm

Lightbox UserForm by Mark Kubiszyn