Introduction

Introducing Mint for Excel

Mint, Self-contained, Sleek, Dark, Easing UserForm Dialog for Excel 2016 (32bit or 64bit, Version 16)

Mint is my latest, self-contained UserForm Code Module Dialog that can be animated in using an Easing Function over your Worksheet to send brief notification messages to your users - Mint is a dark Dialog that can be used on both dark and light backgrounds, with, well, a 'Minty theme' of course!

I wanted to replicate the style of Dialog used for Carbon, but without a lot of the CSS/HTML/JavaScript for tiny message notifications, so I wrote a really simple little Dialog using a single UserForm that you can work with using all of the normal functionality of a UserForm like '.Show 0' but with some extended Property's like using Escape {ESC} to dismiss the UserForm via the '.DisableEscapeKeyFormClosure' Property or the ability to Drag the UserForm around via the '.PreventDraggableForm' Property and even have the UserForm close whenever another Worksheet is selected via the '.UnloadOnSheetChange' Property

Mint started off as Classes using the .Hide() abstraction to override the default functionality of the UserForm, but quickly became overly-complicated, so I retro-fitted it back to easily, understandable VBA Code a novice could probably work with. Mint won't change your life or the World for that matter, but it will give you a warm glow as you fire yet another notification message at your users! Take that, you Minty-loving suckers!

Miint original dark, easing Dialog Box for Excel

Mint Version 1.1 using a slightly smaller Font Size for the Title and Message Text

Mint UserForm with all of the Controls visible

If you love Mint, you may also like Slate, Carbon or Pop

Slate
Carbon
Pop

Prerequisites

Microsoft Excel 2016 Version 16 (32bit or 64bit)
Basic to moderate Excel Skills and some basic VBA skills to use the Mint UserForm Code Module and run the Examples
Windows PC · NOT a Mac!
No support is provided for customization of this Software

Features

Draggable UI Interface - move Mint around with the Mouse
Use Mint as a Modal or Modeless Dialog
Hover highlighting effect on the Buttons
Press {ESC} while using Mint to dismiss the Dialog
Close Mint whenever another Worksheet is selected in Modeless mode
Animate Mint on your Worksheets - 20+ Easing Functions are available
Title and Message are built from HTML parts to use Google Fonts and CSS formatting
Change the Font Size of the Title and the Message Text

Installation

Open Mint.xlsm and test the 3 Examples. To use Mint in your own Projects open Mint.xlsm and your own Macro-enabled Project. Then open the VBE (Visual Basic Editor) and drag the Mint UserForm into your Project. Add and configure any of the 3 Examples to run a Mint Dialog

Usage

How to use Mint

Examples
On the 'Example' Sheet you will find all of the Mint examples. The VBA Code used for all of these examples is in the Example, Worksheet Code Module

The following examples are available:

1. A simple Modeless Dialog with a single button and info icon - easing is: easeBackInQuartic
2. An Error Modeless Dialog with a single button and bug icon - easing is: easeInElasticSmall
3. A Modal Dialog with 2 buttons demonstrating the capture of any of the Mint Dialog buttons

A Mint Example
To bring up a Modeless Mint Dialog using the 'Info' Icon from a click on an Icon, Button or Shape Object, link a Macro ie. Example1() to your Icon (or Object) and then in a Standard Code Module, use the Code below

* .UnloadOnSheetChange = True will force the UserForm to Unload whenever another Worksheet is slected for a Modelsss Dialog
* .PreventDraggableForm = True will prevent a user from dragging the UserForm Dialog
* .DisableEscapeKeyFormClosure = True will prevent a user from using the Escape Key {ESC} to close the Dialog
* .DisableFormEaseOut = True will prevent the Code from using an easeOut, easing function on the Dialog when it is dimissed

Remember to set the .Easing to one of 20+ easing functions
You can set an Icon to be Visible like this: .Bug.Visible = True
Pass in a Title and Message like this: .Title "a Mint dialog with a google font!", .Message "use <span id=themelight>Mint</span> to send tiny <span id=themelight>notification</span> messages to your users"

Public Sub Example1()

   With Mint
      If Not .Visible Then
         .UnloadOnSheetChange = True
         '.PreventDraggableForm = True
         '.DisableEscapeKeyFormClosure = True
         '.DisableFormEaseOut = True
         .Width = 300
         .Height = 140
         .Title "a Mint dialog with a google font!"
         .Message "use <span id=themelight>Mint</span> to send tiny <span id=themelight>notification</span> messages to your users"
         '.CloseCross.Enabled = False
         '.CloseCross.Visible = False
         .CancelButton.Enabled = False
         .CancelButton.Visible = False
         .Info.Visible = True
         .Easing = easeBackInQuartic
         .Show 0
      End If
   End With

End Sub

The Google Font
To change the default 'Comfortaa' Google Font you need to go into the Code inside the Mint UserForm Code Module and search for 'lazyload'. Go to Google Fonts and once you have found your font, choose 'Select this style' in Google Fonts replace the Sections in both Title and Message for v = v & "<link href=""https://fonts.googleapis.com/css?family=Comfortaa:wght@300;400"" rel=""stylesheet"" lazyload>" & Chr$(10). You ae looking at replacing the '=Comfortaa' part. Then replace the CSS part 'font-family: Comfortaa, cursive; font-weight: 400; font-size: 12pt;' for your own Font Family, weights and sizes. Remember to do this for both the Title and the Message HTML parts

   ' replace the Font Family Name, weights and sizes
   v = v & "body                 {background: #2C2C2C; font-family: Comfortaa, cursive; font-weight: 400; font-size: 12pt; color: #717480; overflow: hidden;}" & Chr$(10)
   
   ' replace the Google Font Name, weights and sizes (CSS rules to specify families)
   v = v & "<link href=""https://fonts.googleapis.com/css?family=Comfortaa:wght@300;400"" rel=""stylesheet"" lazyload>" & Chr$(10)

Changing the SVG Icons
The SVG Icons were loaded into an art package called Afinity Designer. I changed the Fill Colour for the Image in Afinity and Exported it a PNG File. I then inserted the Image into Excel and changed the Fill Colour which is now the Background Colour. From here I did a Copy & Paste into the Bug, Cog & Info Images in the UserForm

I used Icons from my Carbon Software that were downloaded from Google Fonts Icons. You can pull these down as SVG which is really great. Here is the Bug Icon with its Outline Fill in Mint and its Background Fill in the Slate Colour I used for the Mint Dialog

Of course you could just add any Image directly into the Image Controls on the UserForm

Screen Shots

A Screenshot of Mint

Mint Version 1.1 using a slightly smaller Font Size for the Title and Message Text

Mint being used as an Error Dialog (as above but with the original Font Size)

Mint being used to capture a Button ie. Okay, Cancel, Close Cross or Escape Key

Mint informing the user of their choice of Button press or Escape Key

The Mint UserForm Class - this is the layout with Hover Buttons and Icons resting on top of one and another

FAQ

* There are currently no FAQ for Mint

Mint Videos

This is a video of Mint in action. In this demonstration, I go through each of the examples on the Example Sheet. Music Get Lost & Found (Original Mix) by Roman Messer, Roxanne Emery Get it Here · view this Mint video on YouTube

Support

Please remember you have purchased very affordable Software and you have not paid for a full-time Software design agency - I am but one man. Occasionally I may help with small tweaks, but these requests will be put on a much lower priority due to their nature. You have not PAID for Support, Support is 100% optional and I provide it for your convenience, so please be patient, polite and respectful

Support (limited) for my Software includes

Responding to questions or problems regarding the Software and its features
Fixing valid (replicated) bugs and reported issues for the VERSION I HAVE WRITTEN

Software support does not include

Customization and installation services
Support for third party software or ANY kind of development whatsoever

Before seeking support

Make sure your question is a valid Software Issue and not a customization request
Make sure you have read through the FAQ's, online documentation and any related video guides before asking support on how to accomplish a task
Ensure that you access to the VBOM is allowed and that Macros can run in Excel
Make sure to provide 'proof of purchase' and state the name / version of the Software that you are having issues with when requesting support by Email or via Facebook

How to get Support

Contact Mark Kubiszyn on the Email address provided when you purchased the Software, including the Order Number
...or Contact Mark Kubiszyn via our Facebook Page - remember to be patient, if there has been an issue with your download, Mark will always respond within 48 hours and will Email you the File directly if neccessary or via Messenger. For other issues the response time may be considerably longer and I may choose to respond to specific questions only (as is my right), depending on what has been asked

Future Builds

* No ideas as yet!

Bug Fixes

* There are currently no bugs identified for Mint

Changelog

Read more information on the status of each release below. The latest Version including a description of any changes is shown first


11.10.2021 - (Version 1.1)

Added the ability to change the Font Size of the Title and the Text
There was an initial Screen Flicker when opening Excel for the first time of the day and running a Mint Dialog, so I am beta testing moving the Dialog off-screen during Initialisation - added Move -1000. -1000 as a test. If this does not produce adequate results then I will use MoveWindow


08.10.2021 - (Version 1)

General release of Mint