Welcome to Kubiszyn.co.uk

This is my Portfolio of creative work for Excel. You can purchase any of these Products or read more information by clicking on the links below · follow the Geek on Facebook or Twitter
Most Popular: Holiday Planner · Pivot Notes · Treelist

Preloader Image 1000px x 654px
Preloader - a Preloader Class for Excel · 2010, 2013, 2016 (32bit or 64bit) & 2019 (64bit) · £2.99

Preloader

#back to top · #videos · #youtube video

The Preloader Class Fades and displays an animation over a Lightbox with a Message to measure the percentage of 'some task'. It uses 3 Shapes for the Lightbox, Animation and Message. It is very flexible and highly configurable. It is farily lightweight, requiring only the Class File and a piece of Code for the Callback to be stored in a Standard Code Module of your VBA Project

RadiObuttons Image 1000px x 654px
RadiObuttons - animationed Radiobuttons for Excel · 2010, 2013, 2016 (32bit or 64bit) & 2019 (64bit) · £2.99

RadiObuttons

#back to top · #videos · #youtube video

RadiObuttons are lovely little animated Radiobuttons for Excel made from 2 Shapes, a Radiobutton and a Circle or Tick. Both Shapes have a Macro assigned. When a Radiobutton is clicked the animation fades in another Circle or Tick Shape to identify it as being Selected. If required you can have a Blank set of Radiobuttons with no Radiobutton being Selected and if so, the Radiobutton runs another animation to remove the Selected Radiobutton

Latest CheckboX Image 1000px x 654px

CheckboX Image 1000px x 654px
CheckboX - a beautiful Checkbox animation for Excel · 2010, 2013, 2016 (32bit or 64bit) & 2019 (64bit) · £2.99

CheckboX

#back to top · #videos · #youtube video

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). When the green Tick is clicked the Checkbox is highlighted with a green line and then a similar animation is ran to rotate and fade it in. You can duplicate and/or add the Code and Shapes very easily into a new or existing Project and capture which Checkboxes are Ticked

Burger Buttons Image 1000px x 654px
Buttons with Animations that Trigger Macros for Excel · 2010, 2013 & 2016 (32bit or 64bit) · £2.99

Burger Buttons

#back to top · #videos · #youtube video

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. All this is linked to a beautifully simple Frame Timer for the animations. You can chose from 3 different animations, adjust the animation speed and the Colour of the animated circle. If you want a ToolTip to be displayed when hovering over the Button, there is an example of how to do this in the download

Burger Button Popup Menu Image 1000px x 654px
Burger Buttons with Animations that Trigger a CommandBarPopup Menu for Excel · 2010, 2013 & 2016 (32bit or 64bit) · £2.99

Burger Button Popup Menu

#back to top · #videos · #youtube video

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 and a Commandbar Popup Menu will 'popup' next to the animation. All this is linked to a beautifully simple Frame Timer for the animations. You can chose from 3 different animations, adjust the animation speed and the Colour of the animated circle. You can edit 3 different types of Popup Menu, classic list, sectioned Menu and a Menu using a Sub-menu. If you want a ToolTip to be displayed when hovering over the Button, there is an example of how to do this in the download

Popup Calendar Image 1000px x 654px
Single Date Pick Popup Calendar Dialog UI for Excel · 2010, 2013 & 2016 (32bit or 64bit) · £2.99

Popup Calendar

#back to top · #videos

PopUp Calendar is a single Date picker Calendar UI for Excel that will 'popup' next to the Cell to enable a user to select a Date. It is based upon an Image I saw on Dribble of a Shipping Date Picker by Alex Saretzky - I loved the UI design, so I built myself one just like it for Excel

Matilda Image 1000px x 654px
Matilda Holiday, Training & Absence Planner for Excel · 2010, 2013 & 2016 (32bit or 64bit) · £2.99

Matilda

#back to top

It's purple, pink and very lovable - Matilda is a beautiful Holiday, Training & Absence Planner in a single Worksheet with a separate, Year and Month Report view. Use UK Bank Holidays or maintain an annual Holiday list of your own. See everything in a Year, grid view or use the Report to detail plotted Dates in a friendly, easy-to-use Worksheet

Rollover Burger Buttons with Animation using easing Functions 1000px x 654px

Rollover Burger Buttons 1000px x 654px
Rollover Burger Buttons with Preloader Animation & easing Functions, Tooltip & Popup Menu to Trigger a Macro for Excel · 2010, 2013 & 2016 (32bit or 64bit) · £2.99

Rollover Burger Buttons

#back to top · #videos · #youtube video

I now have 2 generations of Rollover Burger Buttons on offer. The first generation of Rollover Burger Buttons are small animated Buttons made up of 3 Shapes and a Label that are Grouped together. One of the Shapes is the Icon or Image used for the Button, the second Shape is the Shape that pops up when the Button is 'Rolled over' and the third Shape is the Shape that is animated for a Button click. The Label sits underneath them all to provide the 'Mouse Move' event used to trigger the Timer. When a Rollover Burger Button is clicked the animated circle will be displayed and the linked Macro will be ran. If the Mouse is still over the Button after the Code has ran, then the Button will be in the 'Rollover' state and the Rollover Shape will pop back up. All this is linked to a beautifully simple Frame Timer for the animations. You can chose from 4 different Button animations, adjust the animation speed and the Colour of the animated circle. If you want a ToolTip to be displayed when hovering over the Button, there is an example of how to do this in one of the download Files. There is also an example of using a Popup Menu with a Rollover Burger Button. The second generation of Rollover Burger Buttons use a Hyperlink Rollover Cell, 2 Shapes, one for a Button and the other for the animation. They also feature easing Functions to give a beautifully smooth spin and bounce animation. The Button images are both 48px and 64px (Please Note: second generation Buttons do not have a Tooltip) - all the Files are packaged together as one Zip Archive available to purchase now >>

Fontheads Image 1000px x 654px
Distribute Invisible Embedded TTF Fonts in Excel Workbooks · 2010, 2013 & 2016 (32bit or 64bit) · £2.99

Fontheads

#back to top

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. The Font data is compressed and stored internally within 'Sheet1' of the Workbook. Once installed, the Font can then be accessed via the Drop-down Font Menu on the 'Font' Group of the 'HOME' Tab on the Ribbon and used as normal. When distributing the Workbook, the Font will follow the Workbook and be seen by anyone opening the File

Pop Image 1000px x 654px
Scalable Message Dialog UI with Lightbox - using Icons, Preloaders & Links · 2010, 2013 & 2016 (32bit or 64bit) · £5.99

Pop

#back to top · #videos

Pop is a Scalable, Flexible, Bespoke Message Dialog UI for Excel built using VBA/HTML/Javascript/CSS in a WebBrowser Control, featuring Icons, Images, Text, Buttons, a Progressbar and Preloaders. It includes a Javascript Fade-out for the Dialog Box when closed by a Button or the small Close Cross

My thanks go out to Petros Chatzipantazis, Elvis Zem, the guys at Spreadsheet1 who were instrumental in helping me get the best out of Pop, making suggestions for Scaling and Callbacks and helping with centering across multiple monitors - thanks guys!

Msg Image 1000px x 654px
Dialog UI with Icons, Preloaders & Lightbox for Excel · 2010, 2013 & 2016 (32bit or 64bit) · £5.99

Msg

#back to top

Msg is a bespoke HTML/CSS/Javascript notification Message box with hover buttons, Icons & Preloaders for Excel to inform users of success/info, errors, warnings and help, featuring a lightbox overlay for Excel. You can display a Message that has a timeout and will disappear after a specific duration. Msg comes in 4 flavours, success/info, critical error, warning and help. Msg, Messages can be triggered from Buttons or Hyperlinks. Users can click anywhere within the LightBox, press Escape or click on the tiny white cross to close the Message. Msg can be used whilst a task is running using a Callback feature

Holiday Planner Image 1000px x 654px
Any Year, any Week Day, Holiday, Training & Absence Planner for Excel · 2010, 2013 & 2016 (32bit or 64bit) · £2.99

Holiday Planner

#back to top

An Excel-based any Year, any Week Day small Business Holiday, Training and Absence Planner, featuring Julian Calendar with UK Bank Holidays, ISO Week numbers, Week Days and Dates. The Holiday Planner allows you to plot Holiday Days, Training Days and Absence Days and up to 5 configurable Codes against 100 Employees (without modification), collating the Monthly statistics into a simple Summary Worksheet. The Calendar Year view gives you a detailed view by Employee of all of the Holiday Days, Training Days and Absence Days booked in a Grid format for the selected Year. Full Days Booked are shown as a solid Fill Colour and half-days are shown as shaded. Options allow you to show or hide Bank Holidays and Weekends on the "Calendar Year" Worksheet or any of the individual Calendar Month Worksheets. Version 2 allows you to choose any Week Day to begin the Calendar Year and the individual Calendar Worksheets

Treelist Image 1000px x 654px
Create a Hierarchical Treelist with Collapsible & Expandable Nodes for Excel · 2010, 2013 & 2016 (32bit or 64bit) · £2.99

Treelist

#back to top

Treelist uses hierarchical data to create lists of Items in an Excel Worksheet that can expanded and collapsed at Parent Nodes. When the Nodes are expanded or collapsed any descendants that are already expanded or collapsed persist. The finished list can be copied into a new Workbook or an existing Project - all of the Code is generated in a self-contained "Template" Worksheet Code Module

Pivot Notes Image 1000px x 654px
Filter, sort and slice multiple columns of Pivot Notes for Excel · 2010, 2013 & 2016 (32bit or 64bit) · £2.99

Pivot Notes

#back to top

Pivot Notes allows you to store multiple Columns of Notes and Formula alongside one or more Tabular or Outline Pivot Tables and use the +/- Buttons to Expand or Collapse separate hierarchy's of Note Columns. You can Filter or Sort Pivot Items and the Notes will persist. If the Pivot Table Source data changes, you can Index the Table to store new Notes whilst retaining any existing Notes

Flashbar Image 1000px x 654px
A Nanoscopic Notification Flashbar Animation for Excel · Excel 2010+ · £2.99

Flashbar

#back to top

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. It has a subtle use as opposed to a Message Box which requires user interaction. This type of animation is widely used around the Internet as an indicator when loading Pages etc.

Montage Image 1000px x 654px
Creates a Layout Worksheet for you to Add Images & Print or Save As PDF for Excel · 2010, 2013 & 2016 (32bit or 64bit) · £2.99

Montage

#back to top

Montage creates layout Worksheets for you to add images. It fits the Images to the Cell dimensions and uses Cell Formatting with Image transparency to make beautiful montages. You can create "A4", "A3" or Custom Worksheets, ready to Print or Save as PDF. Measurements are in "CM" or "INCH" and you can choose the Image size, the Cell Shape, the Border size and the Cell Format. You can embed the Images or Link the Images and apply Transparency to allow the Cell Format to come through underneath the Images. Montage includes standalone Code that you can use in your own Projects to select any number of Cells and Embed Images