Free Stuff

Download all of my free stuff at Kubiszyn.co.uk

Here is a full listing of all of my free stuff available for you to download. You can sort the list by clicking on any of the Headers. Search 'Fix' for helpful advice on fixing issues or 'How to' for advice on a range of subjects. Search 'Formula' for formula examples. If you have used any of my other work and wish to donate, you can do so on my Donate Page
Please Note: all of this work is licensed under an MIT License (MIT) and Support is NOT given under any circumstances

Project Name File Size Date
Core Subroutines mdlCoreSubroutines.bas 242 KB 29/06/2016
Animated Waitbar 1 Animated Waitbar.xls 162 KB 09/06/2012
Animated Waitbar 2 Animated Waitbar.xlsm 76 KB 09/06/2012
Cool Text Fade Routine Cool Text Fade Routine.xlsm 86170 KB 24/09/2016
ADODB SQL Example ADODB SQL Example.xlsm 98160 KB 05/03/2015
Display what is being Autofiltered AutoFiltered.xlsm 26 KB 10/06/2018
GetAsyncKeyState Capture Mouse Clicks or Arrows GetAsyncKeyState Capture Mouse Clicks or Arrows.xlsm 15 KB 04/09/2017
Install, Read, Delete Custom Property Custom Properties.xlsm 17 KB 17/05/2018
Delete Duplicates Delete Duplicates.xlsm 16 KB 17/05/2018
Draw Directly on the Screen when Moving Mouse over UserForm Draw Directly on the Screen when Moving Mouse over UserForm.xlsm 20 KB 17/05/2018
Flash Window Flash Window.xlsm 16 KB 07/01/2018
Get UserForm DC Get UserForm DC.xlsm 18 KB 04/11/2017
Picking up list data Picking up list data.xlsm 15 KB 22/01/2018
Rename all Files in a Folder Rename Files in Folder.xlsm 18 KB 14/07/2018
Replace a Format Colour Replace a Format Colour.xlsm 29620 KB 14/07/2018
Build and Select a Range X Columns by Y Rows from a Start Cell Build and Select a Range X Columns by Y Rows from a Start Cell.xlsm 15 KB 02/02/2018
Super AutoFilter and Range AutoFilter Super AutoFilter.xlsm 194500 KB 02/02/2018
Table Example of Fixing Headers as Excel Workbook Headers Table Example of Fixing Headers as Excel Workbook Headers.xlsx 9 KB 22/08/2018
VBA CountIf Replacement VBA CountIf Replacement.xlsb 86170 KB 01/03/2015
Using Defined Names Using Defined Names.xlsm 18 KB 02/04/2014
Tree Node Diagram Tree Diagram.xlsx 13 KB 02/04/2014
Toggle Button Toolbar (with Ribbon pointer restore) Toggle Button Toolbar (with Ribbon pointer restore).xlsm 68 KB 28/05/2015
Toggle Autofilter Toggle Autofilter.xls 42 KB 28/05/2015
Transpose 1 Transpose.xls 120 KB 17/04/2012
Transpose 2 Transpose2.xls 133 KB 09/10/2014
Transpose List Data from Row into Column using Formula Transpose Lists using Formula.xlsx 12 KB 06/07/2017
Blood Pressue Tracker BloodPressureTracker.xlsx 71.6 KB 13/05/2017
Disable And Enable A Button Form Control On A Worksheet Disable and Enable Form Button.xlsm 17.6 KB 29/06/2016
Create Pair Combinations CreatePairCombos.xlsm 20 KB 30/05/2017
Create Treble Combinations CreateTrebleCombos.xlsm 19 KB 09/10/2016
Array as Union of Worksheet Ranges Array as Union of Worksheet Ranges.xlsm 36 KB 08/03/2015
Copy and Paste from the Clipboard using VBA Copy and Paste from the Clipboard using VBA.xlsm 15 KB 09/10/2018
Create Unique List with Counts (1,048,576 Cells) Count Unique List with Counts.xlsb 83890 KB 01/03/2015
Custom Formats Custom Formats.xlsx 11 KB 04/09/2015
XY Scatter Chart with 2x2 and 3x3 Shaded Grid XY Scatter Chart with 2x2 and 3x3 Shaded Grid.xlsx 902 KB 12/03/2016
Truncate Truncate.xlsx 10 KB 12/03/2016
LOGEST, LINEST Calulations LOGEST, LINEST Calulations.xlsx 10 KB 12/03/2016
Excel Reporting Boilerplate excel boilerplate.xlsm 218 KB 14/05/2013
Browse for Folder Subroutines (old and new dialogs) Browse for Folder.xls 218 KB 14/05/2013
Browse for Folder Subroutines (old and new dialogs) Browse for Folder.xls 218 KB 14/05/2013
Kwick Browser featuring Kwicks for jQuery by Jeremy Martin Browser.xlsm 106 KB 16/06/2012
Fast Eval Match Eval-Match.xlsb 118350 KB 09/10/2018
Nice 3 Colour Chart Template Nice 3 Colour Chart Style Template.xlsx 19.6 KB 18/06/2012
Nice Custom Combination Chart Template Custom-Combination-Chart.xlsx 15 KB 26/11/2016
Detect Shift Key Detect-Shift-Key.xlsm 16.2 KB 25/02/2015
Detect Shift Key Checking and Opening a CSV File.xlsm 18.3 KB 05/03/2015
Cleaning Sales (Outlier Correction and Exponential Smoothing) Cleaning Sales (Outlier Correction and Exponential Smoothing).xlsx 18.3 KB 05/03/2015
Email, CC, BCC From List of Names Macro Email From a List Macro.xls 44 KB 13/02/2013
Email Worksheet from Hyperlink Email Worksheet from Hyperlink.xlsm 27 KB 13/02/2013
Derive Unique List from 2 Worksheets of Data by Formula Derive Unique List from 2 Worksheets of Data by Formula.xlsx 231 KB 13/02/2013
Email Template Email-Template.xls 350 KB 24/06/2011
Pickup Data into Array Pickup_Mass_Data.xls 41 KB 29/04/2012
Blue Excel Button Blue Excel Button.xlsx 11 KB 05/10/2014
Fade a Message Window In and Out Fade In and Out Mesaage.xlsm 29 KB 28/11/2013
Delete Rows by HyperFilter HyperFilter.xlsm 29 KB 22/02/2015
Filterlist Dialog, Searchable, Filter Listbox Control Filterlist.xlsm 259 KB 14/04/2013
Create a Unique List of Key and Items from Multiple Worksheets Hyperlist.xlsm 549 KB 14/04/2013
Conjunction Tool Conjunction Tool.xlsm 408 KB 11/12/2012
Unhide Hidden Named Ranges Display, List & Unhide Named Ranges.xlsm 16 KB 12/11/2012
Facebook Loader Facebook Loader.xls 19 KB 13/10/2012
Facebook Loader 1 Orange Ajax Loader.xls
101 KB 30/10/2012
Facebook Loader 2 Orange Spinner Loader.xls
146 KB 30/10/2012
Facebook Loader 2 Blue Bubble Loader.xls 108 KB 30/10/2012
Handling Hyperlinks Handling Hyperlinks.xls 46 KB 30/10/2012
Tile a Worksheet Tile Worksheet.xlsx 17.1 KB 03/10/2012
Free Background Tiles Background Tiles.zip 449 KB 03/10/2012
Find Header and Iterate Range Examples Find Header and Iterate Range Examples.xlsm 23.5 KB 13/03/2015
Minimal Excel Workbooks 1 Clean Single Sheet Minimalist Excel Workbook.xlsm 15.5 KB 03/10/2012
Minimal Excel Workbooks 2 Minimalist Survey Workbook with Single Ribbon Tab, Group & Button.xlsm 17.9 KB 03/10/2012
Minimal Excel Workbooks 3 Clean Reading View.xlsm 23.7 KB 03/10/2012
Colour Picker 1 Colour Picker.xlsm 22.8 KB 04/01/2014
Colour Picker 2 Color Picker 2012.xls 19 KB 04/01/2014
Colour Picker 3 Colour Picker 2012.xls 58 KB 15/10/2012
Colour Picker 4 Colour Picker 2012.xlsm 20.8 KB 15/10/2012
Hide Pivot Table Columns Hide Columns in Pivot Table Data Range.xlsm 29.6 KB 04/01/2014
Multiple Slicers Using Multiple Slicers with Multiple Pivot Tables.xlsm 31.2 KB 12/03/2017
Adaptive XY Rollover Technique XYRollover.xlsm 15.7 KB 10/12/2013
Rollovers 1 Rollover Example.xlsm 32.9 KB 10/12/2013
Rollovers 2 Standard Report Schema (Rollover-enabled).xlsm 22.2 KB 10/12/2013
Rollovers 3 Business Report Schema (Rollover-enabled).xlsm 22.2 KB 10/12/2013
Rollovers 3 Disable Cursor Movement in Menu.xlsm 21.7 KB 10/12/2013
Juiicy Rollovers Juiicy-Themes.zip 201 KB 30/11/2013
Read File Byte by Byte and Debug Print the Contents Read-File-Byte-by-Byte.xlsm 16 KB 10/04/2018
Select and Paste Multiple Range Areas Select & Paste Multiple Range Areas.xls 52 KB 01/05/2013
Data Validation Using RegEx Regular Expressions.xlsm 18 KB 16/11/2013
RegEx Patterns RegEx-Patterns.txt 4 KB 16/11/2013
Protecting Cell Integrity Protecting Cell Data Integrity.xlsm 19.7 KB 10/10/2013
Jagged Array Data En Masse Pick up Data En Masse.xlsm 18.9 KB 18/10/2013
Typography Typography.zip 196 KB 04/10/2013
Metro Rollover Menu Metro Menu.zip 36.2 KB 01/10/2013
Create Worksheets By a List Create Worksheets by List Macro.xlsm 110 KB 24/10/2014
Sort Jagged Worksheet Array Data Jagged Sort.xlsm 3430 KB 24/10/2014
Transpose Horizontal Data Transpose Horizontal Data.xls 132 KB 09/10/2014
Transpose Horizontal Data Args Transpose Horizontal Data with Function Args.xls 120 KB 09/10/2014
Five Year Rolling Calendar Rolling ISO 5 Year Calendar for Week Lookups.xlsx 33.2 KB 06/10/2014
Calendar 1 Calendar.xls 71 KB 04/10/2014
Calendar 2 Calendar.xlsm 38 KB 04/10/2014
Calendar 3 Calendar-v3.xlsm 38 KB 04/10/2014
Calendar 4 Calendar-v4.xlsm 39.7 KB 16/12/2014
Hamilton Largest Remainder Method Hamiltons Largest Remainder Method using the Hare & Droop Quota.xlsx 15 KB 01/09/2014
Lotto Hotpick Analyser lotto hotpick analyser.xlsm 3140 KB 11/05/2014
Resize Range and Formula on Paste 1 Copy & Paste to Resize Range and Automatically Adjust Formulas to Match.xlsm 18.6 KB 06/02/2014
Resize Range and Formula on Paste 2 Copy & Paste to Resize Range and Automatically Adjust Formulas to Match (as values).xlsm 18.6 KB 06/02/2014
Full Screen Fade Overlay Fade Overlay.xlsm 54.2 KB 01/01/2014
Generate Text and Number Combinations Generate Combinations using Formula.xlsx 23.5 KB 01/10/2015
Read and Import CSV Files 1 Read & Import CSV Files.xlsm 23.1 KB 09/09/2015
Read and Import CSV Files 2 Test Data.csv 14.2 KB 09/09/2015
Prevent Multiple Pivot Table Slicer Selections Prevent Multiple Pivot Table Slicer Selections & Capture Mouse Clicks.xlsm 23.9 KB 20/05/2015
Hide or Minimise the Ribbon Hide Ribbon.xlsm 10.8 KB 16/05/2015
Hide or Minimise the Ribbon Persist Hide Ribbon & Persist FullScreen When Minimized.xlsm 12.5 KB 16/05/2015
Hide or Minimise the Ribbon SendKeys Hide Ribbon SendKeys.xlsm 10.8 KB 16/05/2015
Radio Button Radiobutton.xlsm 18.2 KB 27/02/2015
Check Box Checkbox.xlsm 16.2 KB 25/02/2015
Tick Box Tickbox.xlsm 15.5 KB 25/02/2015
Control Pivot Tables With Slicers 1 Using Multiple Slicers with Multiple Pivot Tables.xlsm 31.2 KB 13/05/2015
Control Pivot Tables With Slicers 2 Using a Slicer to Control Multiple Pivot Tables.xlsm 33.2 KB 13/05/2015
Control Pivot Tables With Slicers 3 Using one Slicer to Control Single Pivot Tables on Multiple Worksheets.xlsm 35.4 KB 13/05/2015
Control Pivot Tables With Slicers 4 Dynamic Update of Pivot Table Source.xlsm 19.4 KB 13/05/2015
Control Pivot Tables With Slicers 5 Using individual Slicers to Control Multiple Pivot Tables on Multiple Worksheets.xlsm 47.7 KB 13/05/2015
Control Pivot Tables With Slicers 6 Multiple PivotTables with Individual Slicers on 2 Worksheets.xlsm 36.6 KB 13/05/2015
Control Pivot Tables With Slicers 7 Using Multiple Slicers to Control Pivot Tables on Multiple Worksheets.xlsm 39.1 KB 13/05/2015
Powerpoint Traffic Light Conditional Format Conditional Format PowerPoint.pptm - PowerPoint 48.5 KB 31/08/2016
Resize Alternative For ReDim Preserve Resize.xlsm 66.4 KB 30/08/2016
Transpose Dictionary Alternative For Application Transpose Transpose Dictionary.xlsm 19.7 KB 25/08/2016
UI Elements, Rollover Buttons and Tree List UI Elements.xlsm 45.6 KB 16/04/2016
Rhino Dashboard Template rhino.xlsx 10 KB 01/01/2017
Rhino Dashboard Zip Rhino.zip 204 KB 01/01/2017
Hide Taskbar Routines Hide Taskbar Routines.xls 112 KB 09/03/2012
Kiosk Final Solution The Final Solution, True Full Screen Kiosk Mode.xls 95.5 KB 09/03/2012
Get Range Using Application InputBox Application-InputBox.xlsm 15.4 KB 10/10/2012
Force Cell And Case Formatting Force Case.xls 34 KB 01/10/2012
Generate Random Data 1 Generate Random Text Data.xlsm 18.9 KB 07/11/2012
Generate Random Data 2 Generate Random Numeric Data.xlsm 22.3 KB 07/11/2012
Generate Random Data 3 Generate Random Numeric Row Data Subroutine.xlsm 17.4 KB 07/11/2012
Get Range Data By Header Get-Range-Data.xls 126 KB 10/10/2012
Get Column Letter From Column Number Get-Column-Letter.xlsm 16.3 KB 10/10/2012
Get Column Number From Column Letter Get-Column-Number.xlsm 15.6 KB 10/10/2012
Build And Select Dynamic Range Build-Dynamic-Range.xlsm 16.4 KB 10/10/2012
Get Last Row Get-Last-Row.xlsm 18.1 KB 31/10/2012
Google Charts Google-O-Meter Google-O-Meter.xls 89 KB 16/10/2012
Google Charts Google-O-Meter Deprecated Google-O-Meter Chart Image Generator.xls - deprecated 94 KB 16/10/2012
Message Light Box MsgLightbox MsgLightbox.xls 73.5 KB 16/10/2012
Trial Dialog Trial Dialog.xls 49.5 KB 15/10/2012
Worksheet Browser 1 Worksheet-Browser.xlsm 20.3 KB 10/10/2012
Worksheet Browser AddIn Worksheet Browser.xlam 55.5 KB 10/10/2012
Worksheet Browser Zip Worksheet Browser.zip 106 KB 10/10/2012
Progressbar HTML Sheet Non Modal 1 Progressbar with HTML Sheet (Non Modal).xls 73.5 KB 13/10/2012
Progressbar HTML Sheet Non Modal 2 Non-Modal Progressbar with HTML Sheet Markup.xls 71.5 KB 13/10/2012
Progressbar Markup Non Modal 1 Progressbar with Self-contained HTML Markup (Non Modal).xls 68.5 KB 13/10/2012
Progressbar Markup Non Modal 2 Non-Modal Progressbar Self-contained Markup.xls 66.5 KB 13/10/2012
Progressbar Modal Modal Progressbar with HTML Sheet Markup.xls 71 KB 13/10/2012
Progressbar UserForm Zip Progressbar (Non Modal) FRM.zip 4.44 KB 13/10/2012
Math Functions Sigma And Huge Strings Math Functions.xls, All Math Functions and Sigma 82 KB 22/05/2013
Math Functions Multi-purpose and Multiplication Math Function.xls, Multi-purpose and Multiplication 79 KB 22/05/2013
Sigma Function Sigma Function.xls 36 KB 22/05/2013
Indexing Worksheet Data Using Dictionary Indexing a Worksheet.xls 4710 KB 26/10/2012
Indexing Worksheet Data Using Dictionary Small File Indexing a Worksheet (Blank Data).xls, smaller file to download 48 KB 26/10/2012
List And Move Desktop Icons Desktop-Icons.xlsm 35 KB 26/03/2015
Create Shortcut using VBA Create Shortcut.xlsm 16 KB 21/10/2012
Prime Number Functions Prime-Functions.xls 144 KB 27/10/2012
Prime Number Checker Prime-Number-Checker.xls 41.5 KB 27/10/2012
Purge Workbook Data And Formula En Masse Purge.xlsb 2250 KB 12/09/2014
Sorting Algorithms, Selection Sort Selection Sort.xlsm 21.5 KB 20/05/2013
Sorting Algorithms, Bubble Sort Bubble Sort.xlsm 21.6 KB 20/05/2013
Sorting Algorithms, Insertion Sort Insertion Sort.xlsm 21.4 KB 20/05/2013
Sorting Algorithms, Counting Sort Counting Sort.xlsm 19.3 KB 20/05/2013
Sorting Algorithms, Heap Sort Heap Sort.xlsm 21 KB 20/05/2013
Sorting Algorithms, Comb Sort Comb Sort.xlsm 21.2 KB 20/05/2013
Social Webpage Encoders, Facebook Facebook Social URL Link Encoder.xlsm 25.8 KB 20/10/2012
Social Webpage Encoders, Twitter Twitter Social URL Link Encoder.xlsm 25.4 KB 20/10/2012
Social Webpage Encoders, Linked In LinkedIn Social URL Link Encoder.xlsm 26 KB 20/10/2012
Email Template Outlook email-template (Outlook).zip 2210 KB 20/10/2012
Kiosk 4.1 Full Screen Excel Kiosk4.1.xlsm 149 KB 20/10/2012
Kiosk 4.1 AddIn Full Screen Excel Kiosk4.1.xlam 288 KB 20/10/2012
Kiosk 4.1 Full Screen Excel Zip Kiosk4.1.zip 570 KB 20/10/2012
Full Screen Excel Open Full Screen & Hide Everything Example.xlsm 16 KB 20/10/2012
Full Screen Excel Slideshow Slideshow Example.xlsm 3730 KB 20/10/2012
Kiosk Full Screen Borderless Excel Kiosk.xlsm 49.1 KB 14/06/2014
Kiosk Full Screen Borderless Excel Automation Automation Example for Kiosk.xlsm 15.7 KB 14/06/2014
Kiosk v6 Full Screen Excel Kiosk v6.xlsm 77.2 KB 16/10/2012
Kiosk v6 Dev Full Screen Excel Kiosk v6 Dev.xls 119 KB 16/10/2012
Kiosk v6 Dev AddIn Full Screen Excel Kiosk v6.xlam 115 KB 16/10/2012
Kiosk v6 Dev Zip Kiosk v6.zip 255 KB 16/10/2012
Kiosk v6 Dev Full Screen Excel All Versions Kiosk.xls - all versions 9-14, download and press F4 121 KB 16/10/2012
Ribbon Extensibility XLRibbonX XLRibbonX.xlsm 91.1 KB 25/10/2012
Ribbon Extensibility AddIn XLRibbonX XLRibbonX.xlam 149 KB 25/10/2012
Colour Banding Colour-Banding.xls 41 KB 21/05/2013
Colour Banding, Rollover Colour Banding with Hyperlink Rollover.xlsm 25.4 KB 21/05/2013
Colour Banding, Formula Colour-Banding-Formula.txt 2 KB 21/05/2013
Colour Pallets Report Template Reporting Template Pallet.xls 25.5 KB 03/10/2012
Colour Pallets Office 2013 Office 2013 Pallet.xls 23.5 KB 03/10/2012
Report Template Reporting Template.xls 120 KB 13/10/2012
Generate CVCS Using Formula Generate CVC's using Formula.xlsx 23.3 KB 27/09/2015
CPG Splitter Tool CPG Splitter.xlsm 195 KB 30/08/2014
CVC Generator CVC Generator.xlsm 79.4 KB 23/11/2013
Hamilton Largest Remainder Method Tool Phase & Split.xlsx 132 KB 21/09/2015
Hamilton Product Split Tool Hamilton Promotional Volume Product Split Tool.xlsx 109 KB 01/11/2014
Hamilton Phasing Tool Hamilton Promotional Volume Phasing Tool v2.xlsx 21.5 KB 01/11/2014
Hamilton Promotional Volume Splitter Tool 1 Promotional Volume Splitter.xlsb 252 KB 30/08/2014
Hamilton Promotional Volume Splitter Tool 2 Promotional Volume Splitter (old version).xlsb 124 KB 30/08/2014
Hamilton Hare and Droop Quota Hamiltons Largest Remainder Method using the Hare and Droop Quota.xlsx 15 KB 30/08/2014
Scrolling Category Chart Category Charts.xlsb 477 KB 21/08/2014
Promotional Volume CSV File Creator Promo File.xlsm 300 KB 19/11/2013
Booking System Booking System with Counts.xlsm 159 KB 17/04/2015
Booking System v3 Booking System v3.xls 325 KB 17/04/2015
Booking System v4 Booking System v4.xlsb 99.7 KB 17/04/2015
Booking System v5 Booking System v5.xlsm 186 KB 17/04/2015
Booking System v5.1 Media Demo Media Booking System Demo (version 5.1).xlsm 186 KB 17/04/2015
Booking System v6 Booking System v6 (unfinished).xlsm 67 KB 17/04/2015
Booking System v7 Booking System v7.xlsm 159 KB 17/04/2015
SendMail Template v1.3 SendMail v1.3.xlsm 123KB 02/05/2015
SendMail v2 SendMail.xlsm - version 2 129 KB 02/05/2015
SendMail Widget Report Widget Report.xlsm - mail a report 94.5 KB 02/05/2015
SendMail Widget Report as PDF Widget Report as PDF.xlsm - mail as PDF 94.6 KB 02/05/2015
Build a Ribbon Toolbar Ribbon Toolbar.xlsm 35.6 KB 02/05/2015
Embedding Fonts Embedding Multiple Fonts.xlsb 153 KB 21/04/2015
Rollover Toolbar Rollover Toolbar.xlsb 304 KB 14/04/2015
Rollover Toolbar using Font Awesome Rollover Toolbar Sheet Navigator using Font Awesome.xlsb 629 KB 14/04/2015
Rollover Toolbar Extended Menu Menu.xlsm - extended menu by Emanuelle Lacroix 421 KB 14/04/2015
Rollover Toolbar Extended Full Screen Menu Menu (fullscreen).xlsm - extended menu by Emanuelle Lacroix 420 KB 14/04/2015
Pivot Slicer Button Toolbar 1 Pivot Toolbar.xlsb 307 KB 08/03/2015
Pivot Slicer Button Toolbar 2 Pivot Toolbar.xlsm 39.6 KB 08/03/2015
Pivot Slicer Button Toolbar with OLE Embedded Font Pivot Toolbar (OLE Embedded Font).xlsb 74.9 KB 08/03/2015
Spinner PixelBuddha Preloaders Spinner.xlsm 1030 KB 10/04/2014
Spinner PixelBuddha Preloaders UserForm Spinner UserForm.zip 284 KB 10/04/2014
Spinner PixelBuddha Preloaders Single Spinner Single Spinner.xlsm 431 KB 10/04/2014
Spinner Fade In and Out HTML Spinner fade in and out.html 34.8 KB 10/04/2014
Spinner Fade In and Out Source HTML Spinner fade in and out (source).html 34.7 KB 10/04/2014
Nanoscopic VBA Progressbar 1 Progressbar.xlsm 102 KB 28/03/2014
Nanoscopic VBA Progressbar 2 Progressbar.xls 177 KB 28/03/2014
Nanoscopic VBA Progressbar UserForm Progressbar UserForm.zip 15.3 KB 28/03/2014
Filterlist Fast Flexible Searchable List Control Filterlist.zip 1080 KB 15/04/2013
Filterlist Fast Flexible Searchable List Control Bolierplate filterlist boilerplate.xlsm 1130 KB 15/04/2013
Filterlist Fast Flexible Searchable List Control Autofilter filterlist autofilter boilerplate.xlsm - an example of using Filterlist to Filter data 287 KB 15/04/2013
Delicious Rollover Drop Down Menu Delicious.xlsm 50.1 KB 16/10/2013
Delicious typography delicious.xlsx 14 KB 16/10/2013
Delicious Rollover Drop Down Menu Zip Delicious.zip 100 KB 16/10/2013
Delicious Rollover Drop Down Menu Blue Theme drop-down menu boilerplate (blue).xlsm 33 KB 16/10/2013
Delicious Rollover Drop Down Menu Examples with Multiple Menus & Links to Worksheets drop-down-menu-boilerplate-blue-multiple-menus.xlsm 47.3 KB 14/10/2018
Delicious Rollover Drop Down Menu for Older Excel Versions Delicious-2007-version.xlsm 50.9 KB 16/10/2013
Preloader Transition Using Spin JS Library By Felix Gnass Preloader.xlsm 332 KB 05/08/2013
Preloader Transition Using Spin JS Library By Felix Gnass Zip Preloader.zip 330 KB 05/08/2013
Preloader Transition Using Spin JS Library By Felix Gnass Workbook VBA Projects - Preloader.xls - Blank Preloader Workbook 139 KB 05/08/2013
BI RIBBONX Format Report Data AddIn v1.1 BI__RibbonX.xlsm 56.9 KB 28/12/2016
BI RIBBONX Format Report Data AddIn v1.1 BI__RibbonX.xlam 52.9 KB 28/12/2016
BI RIBBONX Format Report Data AddIn v1 BI__RibbonX (1).xlsm 56.2 KB 28/12/2016
BI RIBBONX Format Report Data AddIn v1 BI__RibbonX (1).xlam 41.6 KB 28/12/2016
Little Chart Widgets LittleChartWidgets.xlsx 74.7 KB 28/05/2017
Dynamic Chart DynamicChart.xlsx 35.4 KB 28/05/2017
Event Planner Demand Event Planner.xlsm 55 KB 12/02/2018
Row Formatting Macro Row Formatting Example.xlsm 24 KB 12/02/2018
Multiplex v6, Fast Array Manipulation Multiplex.xlsm 203 KB 08/10/2018
Multiplex v6 Class, View the Class File as Text Multiplex.clsm 73 KB 08/10/2018
R1C1 Locking Formula in VBA R1C1 Lock Formula.xlsm 16 KB 08/10/2018
Formula to Repeat Column Items X Times Repeat Value X Times.xlsx 10 KB 08/10/2018
Formula to Create a Unique List of Text Items (Case Insensitive) Unique List Formula.xlsx 10 KB 08/10/2018
Formula to SUM Columns by Column Criteria and Row Criteria SUM Columns by Column Criteria & Row Criteria.xlsx 10 KB 08/10/2018
Formula to SUMIF and to Exclude Criteria SUMIFS to Exclude Criteria.xlsx 9 KB 08/10/2018
Formula to do a Backwards VLOOKUP using CHOOSE Backwards VLOOKUP using CHOOSE.xlsx 10 KB 08/10/2018
Formula to SUM Values in a Column until the Next Empty Cell SUM Values in Columns until a Blank Cell.xlsx 14 KB 08/10/2018
Formula to do MOD Patterns, SUM Numbers Every nth Row SUM Numbers Every nth Row.xlsx 9 KB 08/10/2018
Formula to Derive the Last X Weeks Average from Weekly Columns of values Average of X Weeks from Weekly Columns.xlsx 14 KB 01/05/2017
Formula to Identify Duplicates in a List Identify Duplicates in a List using Formula.xlsx 10 KB 01/05/2017
Formula to Reverse or Sort a Column of Data that Cannot usually be Sorted How-to-Reverse-or-Sort-a-Column-of-Data-that-Cannot-usually-be-Sorted.txt 1 KB 08/10/2018
Formula to Extract Product Code and Description Extract Product Code and Description.xlsx 10 KB 08/10/2018
Formula for Boolean Replacement for IF Replacement for IF.xlsx 9.39 KB 08/10/2018
Formula for Boolean Switch Boolean Switch.xlsx 12.1 KB 08/10/2018
Formula Find First Sold In First Sold In Example.xlsx 994 KB 08/10/2018
Formula Find Last Sold In Last Sold In Example.xlsx 773 KB 08/10/2018
Formula Transpose Block of N Rows to Columns Transpose N Rows to Columns.xlsx 10 KB 08/10/2018
Formula Using SUMPRODUCT with Filtered or Hidden Rows Using SUMPRODUCT with Hidden or Filtered Rows.xlsx 11 KB 08/10/2018
Formula to Setup and Format a Rolling ISO Week Number How to Setup and Format a Rolling ISO Week Number.xlsx 11 KB 08/10/2018
Formula to Conditional Format Highlight Dates in Current Year Date Format.xlsx 12 KB 08/10/2018
Formula to SUM or Average the Top 10 or Top X Numbers in a Range AVG Top 10 Numbers.xlsx 11 KB 27/03/2018
Formula for Multiple 3 Column Lookup to Return Single or Concatenated 2 Column Values Multiple Lookups Using Array Formula.xlsx 10 KB 08/10/2018
Formula for Dynamic Named Range or Defined Name to Capture a Range using Offset Dynamic Named Ranges.xlsx 12 KB 08/10/2018
Formula for Top Ten Ranking List Top Ten List.xlsx 16 KB 08/10/2018
Array Formula for SMALL, LARGE, AVG, AND and OR Operators First N Numbers & AND OR Operators.xlsx 10 KB 03/10/2017
First Sold In Formula First Sold In Formula.xlsx 10 KB 27/10/2017
Fix Open the VBA Editor in a Code Module of your Choice Open-the-VBA-Editor-in-a-Code-Module-of-your-Choice.txt 2 KB 08/10/2018
Fix Code execution has been halted Issue Code-execution-has-been-halted.txt 1 KB 08/10/2018
Fix Excel Opens Two Files When Opening A Workbook Excel-Opens-Two-Files-when-Opening-a-Workbook.txt 1 KB 08/10/2018
Fix Hiding Public Subroutines From The Macro Dialog Or ALT And F8 Keypress Hide-Subroutines.txt 1 KB 08/10/2018
Fix Cancel Or Reset Text To Column Settings How-to-Cancel-or-Reset-Text-To-Column-Settings.txt 1 KB 08/10/2018
How to Enable Macros & Trust access for the VBA Project Object Model (VBOM) Enable-Macros-and-Trust-access-for-the-VBA-Project-Object-Model.txt 1 KB 08/10/2018
How to Install and Uninstall AddIns Install-and-Uninstall-AddIns.txt 2 KB 08/10/2018
How to Protect the Data Integrity of Cells Protect-the-Data-Integrity-of-Cells.txt 2 KB 08/10/2018
How to Quickly Multiply lots of Cells by a Number Multiple-lots-of-Cells-by-a-Number.txt 1 KB 08/10/2018
How to Quickly Enter the same Value or Character to lots of Cells Quickly-Enter-the-same-Value-or-Character-to-lots-of-Cells.txt 1 KB 08/10/2018
How to Prevent or Remove the word (Blank) in Pivot Tables How-to-Prevent-or-Remove-the-word-(Blank)-in-Pivot-Tables.txt 1 KB 08/10/2018
Widget Rollover Buttons code-widgets-buttons.xlsm 18.7 KB 17/12/2013
Chocolate & Mint Rollover Buttons Chocolate-Mint-Rollover-Buttons.xlsm 15.2 KB 17/12/2013
Highlight Autofiltered Header Fields in Yellow when Filtered Highlight-Autofilter-Headers-when-Filtered.xls 37 KB 18/02/2009
Dynamically Add Code Subroutine to a Sheet Code Module Dynamically-Add-Code-to-Sheet-Module.xls 20.5 KB 18/02/2009
Dynamically Export a Code Module with Code Export-Code-Module.xls 20.5 KB 28/04/2008
Get the Time Taken to do a Task Get-Time-Taken.xls 37 KB 24/06/2008
BEx Scheduler Sheduler.xlsm 45.8 KB 20/05/2015
Booking System Booking System.xlsm 186 KB 04/02/2015
Multiple Lookups using Array Formula (Lookup 3 Values) Multiple Lookups Using Array Formula (3 Columns).xlsx 10.2 KB 12/11/2015
On Workbook Open Subroutines (which is Fired first) On Open Example.xlsm 12.9 KB 20/05/2015
email-template (Linker) Install & Uninstall as Template (.xls) email-template (Linker) Install & Uninstall as Template.xls 78.5 KB 26/09/2012
email-template (Linker) Install & Uninstall as Template (.xlsm) email-template (Linker) Install & Uninstall as Template.xlsm 40.4 KB 26/09/2012
email-template (Linker) (.xls) email-template (Linker).xls 70.5 KB 26/09/2012
email-template (Linker) (.xlsm) email-template (Linker).xlsm 37 KB 26/09/2012
email-template (Outlook) Install & Uninstall as Template (.xls) email-template (Outlook) Install & Uninstall as Template.xls 182 KB 22/10/2012
email-template (Outlook) Install & Uninstall as Template (.xlsm) email-template (Outlook) Install & Uninstall as Template.xlsm 94.2 KB 23/10/2012
email-template (Outlook) (.xls) email-template (Outlook).xls 163 KB 22/10/2012
email-template (Outlook) (.xlsm) email-template (Outlook).xlsm 93 KB 23/10/2012
Kiosk 4.1 AddIn Zip Kiosk 4.1 AddIn.zip 568 KB 20/10/2012
Open Full Screen & Hide Taskbar Example (requires Kiosk 4.1 AddIn) Open Full Screen & Hide Taskbar Example.xlsm 19.6 KB 13/11/2012
Sending a Widget Report Example (.xls) Sending a Widget Report Example.xls 194 KB 23/10/2012
Sending a Widget Report Example (.xlsm) Sending a Widget Report Example.xlsm 103 KB 23/10/2012
Sort a Row of Data across Many Columns using my Numeric Sort NumericRowSort.xlsm 72.4 KB 18/11/2012
Force Cell Formatting for Font & Font Colour Force Cell Formatting.xls 46.5 KB 02/11/2012
Facebook Loader with HTML Sheet (Non-Modal) Facebook-Loader-with-HTML-Sheet-(Non-Modal).xls 72.5 KB 30/08/2012
Facebook Loader with Self contained HTML Markup (Non-Modal) Facebook-Loader-with-Self-contained-HTML-Markup-(Non-Modal).xls 68 KB 30/08/2012
Facebook Style (.htm) Facebook Style.htm 14.6 KB 21/09/2012
Facebook Base 64 Loader (.htm) Facebook-Loader.htm 5.08 KB 21/09/2012
Ajax Orange Loader (.htm) Ajax Orange Loader.htm 6.42 KB 12/02/2012
Blue Bubble Loader (.htm) Blue Bubble Loader.htm 7.87 KB 21/09/2012
Metro Menu Boilerplate metro menu boilerplate.xlsm 32 KB 14/05/2013
Minimal Metro Menu Boilerplate minimal metro menu boilerplate.xlsm 32.8 KB 21/05/2013
Autofilter, Freeze Panes & Report View Reset Autofilter, Freeze Panes & Report View Reset.xlsm 89.1 KB 20/11/2013
Minimize & Maximize Ribbon height Minimize & Maximize Ribbon.xlsm 12.7 KB 16/05/2015
Another Rollover Technique by Mark Rollover.xlsm 15.3 KB 08/12/2013
BI RibbonX (.xlsm) BI__RibbonX.xlsm 56.2 KB 08/03/2014
BI RibbonX AddIn (.xlam) BI__RibbonX.xlam 41.6 KB 08/03/2014
Juiicy (.xlsx) juiicy.xlsx 13.9 KB 16/10/2013
Juiicy (.xlsm) Juiicy.xlsm 21.19 KB 26/12/2013
Juiicy Zip (lots of Juiicy Stuff) Juiicy.zip 1389 KB 26/12/2013
Nanoscopic Progressbar Progressbar.xlsm 102 KB 28/03/2014
Nanoscopic Progressbar (.xls) Progressbar.xls 278 KB 28/03/2014
Nanoscopic Progressbar Userform Progressbar UserForm.zip 15.3 KB 28/03/2014
Modal Progressbar with HTML Sheet Markup Modal Progressbar with HTML Sheet Markup.xls 86.5 KB 28/03/2014