VBA Index
Mark Kubiszyn
VBA Index (Table of Contents) - free Workbooks and Projects
Free Software Bundle #1: free-software-bundle1Free Software Bundle #2: free-software-bundle2
Free Software Bundle #3: free-software-bundle3
Free Software Bundle #4: free-software-bundle4
A
About (Bauhaus) - Information Dialog Box for Excel featuring a modern interface
About (Vintage Swiss) Fork #1 - Information Dialog Box for Excel featuring a modern interface using a modified Bauhaus Vector Bitmap image
Abstract UserForm Interface - An Abstract UI Option Interface to make changes on User Input in a Geometric Style for Excel (32bit or 64bit, Version 16) · Build Beautiful, Modern UserForms for Excel
Animated Dialog Bundle (Avante-Garde, Wild Oliva & Zingy) - This is a bundle of my top 3 Animated Dialogs including Lightboxes!
Avante Garde Dialog - Avante-garde is an Animated Modal or Modeless Dialog for Excel that can be used as a replacement MsgBox to provide Screen information to end users
Awesome Worksheet Buttons - Awesome Worksheet Buttons - Icon Buttons, Text Buttons, Radiobuttons, Checkboxes and Popup Buttons to press and depress used to toggle an option or setting for Excel (or to capture a Mouse click)
Awesome Worksheet Sliders - Awesome Worksheet Sliders - Slider Buttons that can be Dragged by the Mouse Horizontally or Vertically to Adjust a Value on a Scale within a Range (can also be used with a Chart Series)
B
Black Apple Info Template - This Excel File contains a single formatted Sheet in Black Apple Colours. It is a Dark Theme for Excel that can be used as an Info or About Sheet for a Project or Spreadsheet
Black Apple Template - Black Apple Dark Pivot Table & Table Theme Template for Excel 2016 (32bit or 64bit, Version 16.0) Office 365 runnng Windows 11
Black and White About Template - This Excel File contains two formatted Sheets in 5 Colours with a striped Background and a Squares Background used for any "No fill" parts of the Sheet and an Arial Font of 10pt
Black and White Extended Template - It contains an example of a Pivot Table with a custom 'Black & White Pivot Style', two Slicers with custom Styles, 'Black & White Slicer Style' and 'Black & White Borderless Slicer Style'. The Template also details thin horizontal and vertical lines including a cool 3D vertical line together with a Chart
Black and White Template - This Excel File contains a single formatted Sheet in 5 Colours with a striped Background used for any "No fill" parts of the Sheet and an Arial Font of 10pt
Blue UserForm UI - Here is a Material design that allows you to add interactive Checkboxes, Radiobuttons and Buttons to a UserForm. Blue UI Elements use a minimal Colour theme and gorgeous Graphics. The Images are isolated, edited and then extracted out of a Free PSD Blue UI Kit
BoX UserForm Material UI - A Material Design Excel Dialog built from a UserForm with Flat UI Image Controls using extensibility classes
Boho MP3 Player AddIn - Boho (MP3 Player AddIn) - create Playlists and Play MP3 Music from files on your Computer or Stream from a Website in Excel
Burger Button Popup Menu - Burger Buttons with Animations that Trigger a CommandBarPopup Menu to run a Macro for Excel
Burger Buttons - Burger Buttons are small animated Buttons made up of 2 Shapes that are Grouped together. One of the Shapes is the Icon or Image and the other is the circle Shape which will be animated. When a Burger Button is clicked the animated circle will be displayed
Burger Menu - A Burger Menu is an Icon with 3 horizontal bars, that when clicked by the Mouse, renders a Menu of some description as a Drop-down list of selectable items
C
Calendars (9 Styles) - A set of any Year, any language, perpetual Calendars for Excel 2013 & 2016 (32bit or 64bit), with a FULL language conversion example for Google Sheets
Carbon Dialog (feat. MeepMeep! & Skinny Carbon) - Carbon v2.8 (versions 2.4 - versions 2.8, Dark, Badass), a Professional Animated Modal Dialog Class for Excel 2013/2016 (32bit & 64bit) 2013 & 2016 (32bit or 64bit) - the Zip file contains skinny-carbon, a (low-fat) release of Carbon, skinny-carbon-coolblue-minified, MeepMeep (ACT I)! and MeepMeep (ACT II)!
Carbon UserForm UI - Carbon UI Elements - Interactive Flat UI Images modified from a PSD Carbon UI Kit PSD by Graphicsfuel to use on a UserForm
Card - Minimalist, Modern Dialog UserForm Card, with HTML Label Markup for Excel (32bit or 64bit, Version 16) · Build Beautiful, Modern UserForms for Excel
Card Fork #1 - Minimalist, Modern Dialog UserForm Card, with HTML Label Markup for Excel (32bit or 64bit, Version 16) · Build Beautiful, Modern UserForms for Excel. This is a user fork of my Card Software
Charcoal Template - This Excel File contains a single formatted Sheet with a modified 'Normal' Style, a single Charcoal Border, a striped Background used for any "No fill" parts of the Sheet and an Arial Font of 10pt modified to between 11pt-19.5pt for Headers
CheckboX - CheckboX is a lovely animated Checkbox for Excel made from 2 Shapes, a Checkbox and a Tick. Both Shapes have a Macro assigned. When the Checkbox is clicked the animation rotates and fades a small green Tick in using easeOutQuad (fast, then slow acceleration)
Cube Preloader - Cube Preloader - use as a Progress Indicator to display an animation during the completion of a task for Excel
Cursors - Cube Sets of .ICO Cursors taken from other peoples images. I used the AI File or PSD from the links above and then carefully copied/extracted each Hand Gesture and saved it as an Affinity Designer File. I then Exported the Image as a Transparent .PNG File. Lastly I used Photoshop to save it as an Icon with the .ICO File Type using a Plugin called 'ICOFormat64.8bi'
CSS Dialog Message - CSS Dialog Message - use as a popup to show a message at the bottom of the screen with countdown timer for Excel
CSS Loader - CSS Loader - use as a Progress Indicator to display an animation during the completion of a task for Excel
CSS Task Dialog - CSS Task Dialog - use as a Dialog to manage multiple long-running tasks that you may have in Excel with Percentage Indicator, 8 CSS Preloader Cubic-bezier Animation Timing Functions & 3 Optional Messages
CVC Generator - This CVC Generator allows you to generate Combinations of CVC's (3 levels of different data) in Excel for APO Demand Planning
D
Dark Excel - Dark Excel (feat. Dark Zombie with Disgusting Alerts & Dark Fishbone a Nanoscopic Progressbar) for Excel. Dark Excel & Carbon (Extreme Dark Build) are a perfect match - create sleek projects in a dark mode for Excel. Enhance your Projects, adding Blood-soaked Zombie alerts and a Fishbone Nanoscopic, Statusbar, Progressbar
Dark Fishbone - Dark Fishbone, a Nanoscopic, Statusbar, Progressbar
Dark UserForm UI - Dark UI Elements - Interactive Flat UI Images modified from 2 PSD UI Kits by Freebiesbug to use on a UserForm
Dark Zombie UI - Dark Zombie for Excel. Add Blood-soaked Zombie alerts to your Projects
Date Time Picker UI - Flexible Date Restriction with Single Date Selection from a UserForm Popup Calendar in a Worksheet or from a Textbox on a UserForm for Excel 2016 (32bit or 64bit, Version 16). Now featuring additional Time Picker and various modifications to the UI/Code
Dialog Box - Interactive, Draggable, Modal or Modeless 3D Style Dialog Boxes to use in Excel (32bit or 64bit, Version 16) · Build Beautiful, Modern UserForms for Excel
Drop Down Preloader - Dropdown Preloader with Easing for Excel (32bit or 64bit, Version 16, Office 365) · CHECK BEFORE PURCHASING! You MUST be able to insert animated gif's into excel to use this Software
E
Easing Functions - This Software uses Robert Penners easing Functions converted from JavaScript to VBA. It uses a variety of different resourses to pull together easing Functions that are presented in 4 Files, a legacy example Workbook with a plot Chart, a newer generic easing Function Workbook (legacy examples and my Flyout Animations on a separate Sheet without a plot Chart), a modern easing Cheat Sheet with a Donut demo and an ITeeen Object Animation Class Workbook which demonstrates not only Shape movement, but also UserForm movement
F
Flashbar - Here is a nanoscopic, animated Flashbar for Excel. You can use this animation to inform the user that you have just processed something. As an example, consider after Saving some data giving a quick Flash to the user would be indicative of a successful Save. The Flashbar dynamically creates and destroys a Shape Object, rendering a lovely little Bar across the top of the Worksheet that fades out as the animation ends
Flat Worksheet UI - Flat UI Interface Objects are a collection of Grouped Shapes that can be used to provide interaction to change or update a Setting or Option in Excel. They are taken from various different Projects I currently have for sale and have been modified for this Project, Flat UI. Each Grouped set of Shapes can be moved around a Sheet or copied into another Workbook and configured accordingly by adding any required Defined Names (Named Ranges) and linking the relevant Macros to the individual Shapes
Fontheads - Fontheads are small Excel (*.xlsm) Files that have a minimum amount of Code in the 'ThisWorkbook' Code Module to Install & Uninstall the Font when the File is opened
Form - UserForm Notification Msgbox Class with RGB for Excel 64bit only · use Form to create UserForm Notification MsgBoxes with MouseOver Buttons
G
Generic Template - This Excel File contains a single formatted Sheet with a modified 'Normal' Style, a multi-coloured band at the top, a chequered Background used for any "No fill" parts of the Sheet and an Arial Font of 10pt modified to between 11pt-18pt for Headers
H
Hamilton Phasing Templates - Phase and split buckets of data: 2 Phasing Templates will phase Integer values using Formula across 12 Weeks and prevent loss of Integers by implementing a Largest Remainder method
Holiday Planner - Holiday Planner · An Excel-based any Year, any Week Day small Business Holiday, Training and Absence Planner that works in Google Sheets, SharePoint and Microsoft Online
Hyperlink Rollovers - This Software will combine some of my oldest and very latest (and most awesome) Rollover techniques to give you various options when using the Hyperlink Rollover in your future Projects
I
IEasing Class - This Class allows you to use my ported easing Functions via a Class to animate Shapes, UserForms and Objects in 64bit Excel. easing Functions do not have direction. Each easing Function returns a value dependant on the number of values you require in a second. So from 0 to 1 second, when using 24 Frames per second the easing Functions would return 24 values every 0.0416666666666667 of a second that would indicate the movement steps of the Object from one position to another
ITween Class - This Class allows you to set an Object like a Shape or a UserForm as a 'Tweener' Property of the ITween Class and then animate it horizontally and vertically (width and height is also available) using one of 37 easing Functions embedded into the Class. The Demo Code included with the Class demonstrates both Shape and UserForm animation
Info Bubble - Interactive, Draggable, Modal or Modeless Information Bubbles to use in Excel 2016 (32bit or 64bit, Version 16) · Build Beautiful, Modern UserForms for Excel
K
Kiosk - This is a rare treat! All of my Kiosk Software ever written included in the purchase - where it all began! Kiosk Full Screen Dev Code & AddIns for Excel
L
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 11Lightbox 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
Litebox - A Dynamic WebBrowser-based Easing Lightbox & HTML Container by Mark Kubiszyn for Excel & Access 2016 (32bit or 64bit, Version 16.0)
P
Pivot Notes - Store, Sort & Edit Notes alongside your Pivot Tables. It's been a long time in the making, but it's finally arrived! Pivot Notes 8 replaces all other Pivot Note versions. This version of the Software is faster, smarter and easier to use
R
Retro Dialog - Interactive, Draggable, Modal or Modeless 3D Retro Dialog Box to use in Excel (32bit or 64bit, Version 16) · Build Beautiful, Modern UserForms for Excel. Retro Dialog is a Retro style Dialog image that is loaded into a UserForm. The Titlebar and Borders of the UserForm are removed and the Transparency key is used to turn White areas of the image transparent
Retro Dialog Bundle - This is a bundle of my top 5 Retro Dialogs!
Retro Dialog:
Retro Dialog is a Retro style Dialog image that is loaded into a UserForm. The Titlebar and Borders of the UserForm are removed and the Transparency key is used to turn White areas of the image transparent. It is sized to '400px x '267px' and has an Icon, an interactive Close Cross and two interactive Buttons. Optional Titlebar and Message Labels allow you to specify a Title and / or a Message to the user
Retro Error Msg:
If you want to have a really nice, retro looking MsgBox for Excel then how about using my Error Msg. Error Msg uses my minified Extensibility Class for Excel (redacted from my UserForm-Extensibility Class) to make some aspects of interactivity easier like adding a Hand Cursor to a Close Cross or allowing a UserForm or parts of a UserForm to be transparent and / or dragged by the Mouse
Retro Warning Msg:
If you want to have a really nice, retro looking MsgBox for Excel then how about using my Warning Msg. Warning Msg uses my minified Extensibility Class for Excel (redacted from my UserForm-Extensibility Class) to make some aspects of interactivity easier like adding a Hand Cursor to a Close Cross or allowing a UserForm or parts of a UserForm to be transparent and / or dragged by the Mouse
Retro Info Msg:
If you want to have a really nice, retro looking MsgBox for Excel then how about using my Info Msg. Info Msg uses my minified Extensibility Class for Excel (redacted from my UserForm-Extensibility Class) to make some aspects of interactivity easier like adding a Hand Cursor to a Close Cross or allowing a UserForm or parts of a UserForm to be transparent and / or dragged by the Mouse
Retro Question Msg:
If you want to have a really nice, retro looking MsgBox for Excel then how about using my Question Msg. Question Msg uses my minified Extensibility Class for Excel (redacted from my UserForm-Extensibility Class) to make some aspects of interactivity easier like adding a Hand Cursor to a Close Cross or allowing a UserForm or parts of a UserForm to be transparent and / or dragged by the Mouse