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
Having problem purchasing? Pay via my DONATE BUTTON, message me on Facebook and I will Email the File
Kiosk Full Screen Excel AddIn for Excel 2013+. Go Kiosk mode as Full Screen with a Border, Full Screen without a Border or a Manual Window size with or without a Border. Hide any othe common Excel objects like the Ribbon, Worksheet Tabs, Gridlines, Formula Bar etc. All of the settings before launching are embedded into Excel and added back after pressing {F4}. This is Version 9, the best one yet!
Fed up of staring at the same Pivot Tables and Slicer Styles? Yeah, me too, that's why I designed a tool to create minimilist Pivot Table and Slicer Styles - just select any of the predefined Colours, press a Button and all of the new Styles are adjusted automatically. You can choose to Copy the Style(s) to a Blank Workbook or to a Closed Workbook. You can also just Copy the Worksheet into your Project, then delete it - the Styles will be added into your Spreadsheet to use with your Pivot Tables and Slicers. Use your own Brand Colours to create an instant corporate style. Repivot Version 2+ now comes as an AddIn with more features - you get 3 Files when you purchase Repivot, all unlocked
My mission is to take your Excel UI to another level. You can purchase all of my Material UI and Code Examples in a single UI Pack from the link above or use your own images with any of the Effects Code (where provided). All of my Icons (lightweight SVG Files 3KB) can have both Fill and Outline Colour set in Excel. They are fully responsive and can be added to Excel as a 'Graphic' via Insert->Pictures on the Illustrations Group of the Insert Tab on the Ribbon. These Icons are similar to the new Icons available in Excel 2016 with an office 365 subscription
I also include the EMF Files which are even smaller at 1KB without Transparency so you can add a Shadow without any transparent areas taking on the effect. EMF Files are also fully scaleable maintaining crisp lines no matter what the size
With the UI Pack I also include a Worksheet for the Material UI Teal Fill & Font Colours including links to Websites with Material UI and Colour Harmony. Protection is added to any Code where Shapes are used. I use a method that allows Code to run and also allows you to edit anything except Shapes. To remove this Protection, click 'Unprotect Sheet' on the 'Protect' Group of the 'Review' Tab on the Ribbon. This method is only available to you when you purchase my UI Pack
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
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 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
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. Treelist features include adding a circle animation to the Toggle Nodes when they are clicked, configuring the Node Hairlines and Protecting the Icons whilst allowing full control over the Worksheet
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
