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

Burger Buttons Image 1000px x 654px
Buttons with Animations that Trigger Macros for Excel · Excel 2010+ · £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 · Excel 2010+ · £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 · Excel 2010+ · £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 · Excel 2010+ · £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

Fontheads Image 1000px x 654px
Distribute Invisible Embedded TTF Fonts in Excel Workbooks · Excel 2010+ · £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 · Excel 2010+ · £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

Msg Image 1000px x 654px
Dialog UI with Icons, Preloaders &Lightbox · Excel 2010+ · £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 · Excel 2010+ · £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 · Excel 2010+ · £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 · Excel 2010+ · £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 · 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 · Excel 2010+ · £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