Introduction

Introducing ResponsiveSnackie

ResponsiveSnackie - use as a responsive popup to show a message at the bottom of the screen with the ability to add a Button and capture a click on it for Excel

Add some Text and adjust the formatting. Then send out your popup to the bottom of the Excel Window. ResponsiveSnackie must be clicked in order for it to be dismissed. You can add a Button to ResponsiveSnackie that you capture a Click for. Snackie has been designed to work on both dark and light Excel backgrounds. It is based upon a CodePen by Decatron and has been ported and modified for the IE WebBrowser Control and then customised especially for Excel using VBA by Mark Kubiszyn. Cute Snackie image from imgbin.com. Please Note: ResponsiveSnackie uses jQuery and Font Awesome with the WebBrowser Control. ResponsiveSnackie does not have all of the jQuery library's embedded - they are pulled dynamically from the internet, therefore you must have an internet connection to use Snackie, but then, let's face it, who doesn't these days!?

Prerequisites

Excel 2013 (Version 5) & Excel 2016 (32bit or 64bit, Version 8)
Basic to moderate Excel Skills and some VBA skills to copy the Class Module and add a Code example
Windows PC · NOT a Mac!
No support is provided for customization of this Software

Features

Carry on working in Excel whilst the Responsive Snackbar is displayed. jQuery is fast with nice animations. Font Awesome is used for the Button

Installation

ResponsiveSnackie.xlsm is ready to use (version specific naming of the file will differ with each new release). Open the File and test out all of the Demos. To use ResponsiveSnackie in your own Project, just open ResponsiveSnackie.xlsm and your Project and then go into the VBE Editor. Drag the ISnackbar Class into your Workbook and then just add any of the examples remembering to declare the Private Snacking local variable at the top of your own Code Module. That's it, now get Snacking..!

Usage

ResponsiveSnackie.xlsm

dark & light Tabs
These two Sheets contains all of the Demos for ResponsiveSnackie overlaid onto a Light and a Dark theme. The Dark theme is easier on the eyes and goes hand in hand with my very, very Dark Excel.

Code for a Snackbar (a ResponsiveSnackie)
Using ResponsiveSnackie is easy - here are the three Demo Subroutines (you can set the focus back to the main Application Window by setting the first Parameter, AppFocus to True, otherwise it will mean that the UserForm overlay ie. Snackie gets priority):

    
Public Sub Default_Snackbar()
 
   If Snacking Then Exit Sub
   Snacking = True
   
   Dim Snackie As ISnackbar
   Set Snackie = New ISnackbar
   
   With Snackie
      If .Bar(False) = vbOK Then _
      ActiveSheet.Range("B13").Value2 = "You clicked learn more" Else _
      ActiveSheet.Range("B13").Value2 = "You clicked the Close button"
   End With
   
   Set Snackie = Nothing
   Snacking = False
 
End Sub

Public Sub Snackbar_Simple_Message()
 
   If Snacking Then Exit Sub
   Snacking = True
   
   Dim Snackie As ISnackbar
   Set Snackie = New ISnackbar
   
   With Snackie
      '@Ignore FunctionReturnValueDiscarded
      .Bar False, "Hello World!", "#879"
   End With
   
   Set Snackie = Nothing
   Snacking = False
 
End Sub

Public Sub Snackbar_Responsive_Setting()
 
   If Snacking Then Exit Sub
   Snacking = True
   
   ' add virtual setting for Responsive Snackie Width.  Resize your Excel Window and run the Subroutine again to see the result
   ActiveWorkbook.CustomDocumentProperties.Add "SnackieWidth", False, msoPropertyTypeNumber, 960
   
   Dim Snackie As ISnackbar
   Set Snackie = New ISnackbar
   
   With Snackie
      '@Ignore FunctionReturnValueDiscarded
      .Bar False, "Hello World!", "#879"
   End With
   
   Set Snackie = Nothing
   Snacking = False
   ActiveWorkbook.CustomDocumentProperties("SnackieWidth").Delete
 
End Sub

The Result
Using the above Code you can see the Results below for the Default Snackbar Subroutine, the example used to pass in a Message and then the Responsive Subroutine that is used to force ResponsiveSnackie to fit to the bottom of the Excel main Window when ran:

Get Last Night In The Sky by Shake here https://t.lickd.co/52N06O95YjB

License ID: b9Yxkv3RO7w

Get this and other songs for your next YouTube video at https://lickd.co

ResponsiveSnackie

Default ResponsiveSnackie Screen shot

Snackie on a Light background

FAQ

Q. Can I make Snackie always fit the Size of my Excel Window?

A. Yes, to do this you could use the Application Width divided by an approximation for the Points per Pixel of your Monitor, for example: Application.Width / 0.72. For a more precise calculation you should obtain the correct ratio of Points per Pixel for your Monitor and then use that in the Application.Width calculation

ResponsiveSnackie

This is a video of the default Subroutines for the Dark & Light themes for ResponsiveSnackie

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

* Maybe look at embedding the jQuery libs - something I have done in the past but it does kind of bloat out the Code and is difficult to read in and sucessfully store in the Code Modules

Bug Fixes

* There are currently no bugs identified

Changelog

You can find the version history in the Code Module for any Macro-enabled Software or read more information on the status of each release
- the latest Version including a description of any changes made is always shown first


30.11.2020 - (Version 1) Released

General release of the first version of ResponsiveSnackie