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 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
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 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 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 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
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
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 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
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!
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 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 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
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 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