Notify

Welcome to Kubiszyn.co.uk · click on any of the Featured links within this page to read more about my latest Software available to purchase. Use the Menu at the top of the Page to browse the entire Website, share this page or search for content

Advanced Message Box with Lightbox using Icons & Preloaders for Excel

Updated March 17, 2017 - Version 2

Here 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 beautiful lightbox overlay for Excel. You can display a Message that has a timeout and will disappear after a specific duration. Notify comes in 4 flavours, success/info, critical error, warning and help. Notify 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

Pivot Notes

Store multiple Columns of Notes and Formula alongside one or more Tabular or Outline Pivot Tables

Updated April 19, 2017 - Version 5

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

Treelist

Create a Hierarchical Treelist with Collapsible & Expandable Nodes

Updated March 25, 2016 - Version 3.1

Tree List 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

Holiday Planner

Any Year Holiday, Training & Absence Planner with Julian Calendar for Excel

Updated March 25, 2017 - Version 1.4

An Excel-based any Year 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 against an unlimited amount of Employees, collating the Monthly statistics into a simple YTD Summary. The Calendar 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" Worksheet or the individual Calendar Month Worksheets

Flashbar

A Nanoscopic Notification Flashbar Animation for Excel

Updated October 16, 2016 - Version 1

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.

Progress

HTML5 WebBrowser Progressbar for Excel

Updated November 15, 2016

This Progressbar can be used with DoEvents or an alternative MyDoEvents to display the Percentage and Message of a Task until it is complete, after which it can Fade away or display a Complete Page with Message. I have added the Easing function to slow the rate of the Bar down as it reaches conclusion and the Workbook comes with many examples so you can get a feel as to what can be done including some 'real world' examples

CVC Generator

Generate Combinations of CVC's in Excel for APO (Build Combinations from any Highlighted Cells in 3 Lists)

Updated April 20, 2016 - Version 4.2.1

This CVC Generator allows you to generate Combinations of CVC's (3 levels of different data) in Excel for APO Demand Planning. It takes 6 Columns of data and generates any of the Cells that are highlighted in the Odd Columns and then builds an output File from these selections (it can include the Descriptions too if you want). The Workbook allows you to create your own Table of data and format the output by sorting the Columns, sorting the final output, adding in Blank Columns, inserting new Columns with auto-populated Text Fields, renaming the Headers for the Columns and repeating Columns

Alerts

An Alert Messagebox with Close Cross & Lightbox for Excel 2013

Updated November 7, 2016 - Version 1

Alerts are simple Excel messages that popup over a LightBox. Choose from 4 different Alert Types, vbSuccess, vbWarning, vbInfo (use for Information/Help) and vbDanger (use for Critical Issue/Errors). Alerts can be wider or taller and can show or hide a Title / Message that can also be formatted in HTML. You can dismiss Alerts by clicking on the small cross, by clicking anywhere on the LightBox or by pressing the Escape Key

Sendmail

An Excel White Paper on Sending Images by Email using VBA and Outlook to Avoid the Security Guard

Updated January 30, 2016 - Version 1.0.0.1

This White Paper for VBA Developers demonstrates two methods to send Images by Email using VBA and Outlook. SendMail ensures that Images are Sent by Displaying the Message and letting Outlook embed the HTML Markup. SendMail2 uses the Outlook.PropertyAccessor to Attach and hide embedded Images referencing the modified HTML Markup for Images with a 'CID:' Tag. Both SendMail Subroutines use the Outlook Progress Dialog to force a Send & Receive in Outlook either by displaying the Email first or silently Sending the Email without displaying. Mail and MAPI Namespace Objects are invoked via Late Binding. The Default Mail Profile for Outlook on the Local Machine is used to send Email. Sendmail features 32 Examples with full Code

Easing Functions

Easing Functions - Animations with Frame Timer for Excel 2013

Updated October 20, 2016 - Version 1

Alerts are simple Excel messages that popup over a LightBox. Choose from 4 different Alert Types, vbSuccess, vbWarning, vbInfo (use for Information/Help) and vbDanger (use for Critical Issue/Errors). Alerts can be wider or taller and can show or hide a Title / Message that can also be formatted in HTML. You can dismiss Alerts by clicking on the small cross, by clicking anywhere on the LightBox or by pressing the Escape Key

Blood Pressure Tracker

Blood Pressure Tracker - Monitor & Print your Blood Pressure from 4 Weeks to 6 Months with Chart & Summary Sheet

Updated May 13, 2017 - Version 2

This Excel Blood Pressure Tracker allows you to record 1 to 4 daily Readings for up to 6 Months and then display a summary of all of the Readings ready to Print. It has full instructions with an easy setup Worksheet and contains no Code. Data Entry is simple and the Summary Worksheet analyses all of your Readings and displays them in a readable format that you can Print as A4 Sheets to take along to the Doctors if they request that you track your Blood Pressure