Introduction

Introducing Awesome Buttons

Awesome Buttons - Icon Buttons, Text Buttons, Radiobuttons, Checkboxes and Popup Buttons to press and depress used to toggle an option or setting for Excel (or to capture a Mouse click)

These awesome Round Icon Buttons can be used as a switch to toggle a setting On/Off in Excel or can capture a Mouse click and perform some action thereafter. Designed from scratch, I use 2 to 3 Grouped sets of Shapes (which includes a Graphic Icon) depending on how I want to use them. I suffix each group with 1, 2, 3 etc. to allow the code to distinguish which Grouped Button set is being activated on a Sheet. Then I link up a Subroutine to change the look and feel of the Buttons. The latest version is version 1.5

Important Version Updates
Version 1.1 features Awesome Rectangular Text Buttons in the same style as the Round Icon Buttons but allowing you to toggle two different Text values ie. ON and OFF
Version 1.2 features Awesome Radiobuttons that a user can make a choice from a range of different options and then you can store the result in a Defined Name
Version 1.3 features Awesome Popup Buttons - Buttons that you can depress and hold the Mouse down on, before releasing and letting them spring back to their initial setting. You can run Macros after pressing the Buttons
Version 1.5 features the addition of 2 new Subroutines that can be linked to Buttons to enable Nested Groups of Buttons and Shapes ie. Buttons, a Menubar and Dividers. These 2 Subroutines provide the Macros to drive default Toggle Buttons and Popup Buttons and use the Macros, AltToggle() and AltPopupToggle(). I added an example Sheet, 'Awesome Buttons (Alt. Method)' to demonstrate a standalone Button that uses the technique and then Buttons that are Nested within multiple Grouped Shapes

If you like this Project you may also enjoy


Flat UI ·  Slider Toggle Buttons ·  Sliders ·  Small Toggle Buttons ·  Menubar ·  Toggle Buttons ·  xlui ·  RadiObutton ·  CheckboX ·  Burger Buttons ·  Popup Burger Buttons

Prerequisites

  • Excel 2013 (Version 5) & Excel 2016 (32bit or 64bit, Version 8)
  • Basic to moderate Excel Skills and some VBA skills to copy a Grouped Shape and then link a Subroutine to a Shape and a Graphic object
  • Windows PC · NOT a Mac!
  • No support is provided for customization of this Software

Features

  • Copy the Grouped Buttons or the entire Sheet to make more Buttons
  • Lots of examples to get you up to speed with how to use the Buttons
  • An alternative Method that allows single Buttons and Nested Grouped Buttons and Shapes to be used (both default Button and Popup Button Macros are included for you to link up to the Icons and Buttons
  • Store the Toggled values in the Sheet or as Defined Names/other Ranges
  • Stack the Grouped Buttons to allow an Enabled/Disabled action to be changed via VBA Code
  • Press and hold the Popup Buttons with the Mouse. Release them to run a Macro
  • Create Checkboxes using the Popup Buttons with alternative Icon Shadows
  • Rectangular Text Buttons allowing you to toggle two different Text values ie. ON and OFF
  • Radiobuttons to allow a user to make a choice from a range of different optons and store the result in a Defined Name
  • Store multiple sets of Radiobuttons on a single Sheet
  • Change the Icon size and colour
  • Use TRUE/FALSE or zero (0)/-1 to act upon changes
  • They look great at 150% or 100% on the bespoke background or on a white background or a background with no Fill
  • Protect the Shape and Graphic Drawing Objects via VBA Code to prevent Selection


















Installation

Awesome Buttons.xlsm is ready to use (version specific naming of the file may differ with each new release). Open the Awesome Buttons.xlsm File and test out the Buttons on the various Worksheets to see how they work and store their respective setting values that determine their status. In order to select any of the Shapes or Graphic Objects you must first Unprotect the Sheet

Usage

Awesome Buttons.xlsm


Using the Awesome Round Icon Buttons in your own Project
Sheet Example1 is an example of using simple toggle Buttons iin a Worksheet. Now we will do this from scratch to detail how it is done in your own Projects. To use the Awesome Buttons in your own Project, first Unprotect the Interface by doing Unprotect Sheet on the Protect Group of the Review Tab on the Ribbon. Right-click a Shape and use the Selection Pane on the Editing Group of the Home Tab of the Ribbon to make Selections easier. In order to select any of the Shapes or Graphic Objects you must first Unprotect the Sheet. To create a simple Button that you can press and depress in Excel, Select the first Normal Grouped Shape and Copy it to the Clipboard. Select your own project and Paste it into a Worksheet. Repeat this for the Depressed Grouped set of Shapes as well so you end up with something like this:



Now we need to add the Code that will sit behind the Buttons. Open the VBE Editor (go into the Visual Basic Code, ALT+F11) and drag the 'mdAwesomeButtons' Code Module into your own Project. You should have something like this:



Now click or right-click a Shape and use the Selection Pane on the Editing Group of the Home Tab of the Ribbon to make Selections easier. Drag the Normal Grouped set of Shapes to the top of the Selection Pane. Select the NormalIcon and then right-click near the actual Icon and choose 'Assign macro' picking the 'AwesomeButtons.xlsm!Toggle' Macro. Repeat this for the NormalButton and then do the same for the Depressed Icon and Button - this is what I mean:



Set up 2 Defined Names called 'Button' and Button1' to any Cell on the Sheet with the Buttons. Now before you go pressing anything, select both Grouped Shapes in the Selection Pane and on the Arrange Group of the Shape Format Tab on the Ribbon, choose Align, Align Center and Align, Align Middle to align the set of Shapes. Now press the Button. Your Button should Toggle and store its Button Status like this - look how the Selection Pane shows the hidden and visible objects:



Changing the Alt. Text of the Toggle Buttons
I have done the hard work for you already, however if you have an error when creating a new Toggle Button then remember to edit the Alt. Text as per the image below (set to Button, Button1, Button2 etc. for the Code to work correctly when using my Subroutines). Please note: Defined Names must be created to match these Alt. Text names so that the Code can set the Button Status accordingly



Stacking, to allow disabling via VBA
To allow VBA Code to display a Disabled Button, you need to Stack another Button together with the 2 Buttons used previously to create the Awesome Buttons. This third Grouped set is called Disabled. Go to the Sheet Example2. Play around with the Buttons clicking the 4 Square Buttons to Disable and then Enable both sets of Awesome Buttons. You simple Select all 3 Buttons and then align them as before by their center and middle. The Disabled Button set does not require the Alt. Text to be set. Go into the Code and examine the Macros used to do the toggling



Capturing Mouse Clicks via VBA
Go to Sheet Example3. Here is a demonstration of capturing Mouse Clicks and then acting upon them. In my example I toggle the Sheet Headings and the Sheet background colour. The Macro linked to do this is called CaptureToggle and the Subroutines that this Macro uses are placed at the bottom of the Code Module. Examine how I use the DisableButton and EnableButton Subroutines that are linked to the 4 Square Buttons in the example. Below are two images of capturing the Mouse Clicks on the Play Button to turn the Headings Off





SVG Icons
Each Buttons uses an SVG Icon. SVG Icons should be the same for all 3 Grouped Buttons so as to look uniform, but they don't have to be. To change the Icon, you first need to Unprotect the Worksheet. Then right-click the Graphic Object or any Shape and use the Selection Pane on the Editing Group of the Home Tab of the Ribbon to select the NormalIcon, DepressedIcon or DisabledIcon in a Toggle Group. Now choose, change Graphic, from Icons on the Change Group of the Graphics Format Tab on the Ribbon and pick another Icon

New for Version 1.1 - Awesome Rectangular Text Buttons
Version 1.1 features Awesome Rectangular Text Buttons in the same style as the Round Icon Buttons but allowing you to toggle two different Text values ie. ON and OFF





New for Version 1.2 - Awesome Radiobuttons
Version 1.2 features Awesome Radiobuttons in the same style as the Round Icon Buttons allowing you to make and store a Selection within a range of different options ie. What Pet do you own? Dog, Cat or Other





Tips
Resizing the Awesome Round Icon Buttons to create larger or smaller ones:
Unprotect the Worksheet and select the Toggle Grouped Shape. Hold down Shift and then drag the object to resize it

Changing the Text for the Rectangular Text Buttons:
On the Selection Pane make sure that one of the sets of Buttons is switched Off (it should have an eye-dropper with a line through it). Then select the other set and the Text Shape. Now adjust the Text value for that Shape. Then reverse this action, hiding the Text Shape you just adjusted and showing the other Text Shape. Now adjust the Text value for that Shape as well

Using TRUE/FALSE instead of the zero (0) and -1 values captured for changes:
To use TRUE/FALSE or True/False as the captured changed values enusre that the Button Status is Off (Depressed) and type FALSE over the zero (0) value and then Press the Button



Awesome Buttons

The 3 Awesome Round Icon Buttons that make up this Project

Play & Refresh/Recycle Simple, clickable Awesome Buttons displayed at 100% Zoom

Awesome Buttons detailing how to Disable & Enable Buttons via VBA Code (0 means that the Button is Enabled, 1 means that the Button is Disabled and -1 means that the Button is Depressed)



Capture Awesome Button Mouse Clicks. Play was pressed, so the Button will be Depressed and the Headings will be turned Off

Hiding the Headings after capturing a Mouse Click

The 3 Awesome Rectangular Text Buttons that make up this Project

You can adjust the Text for both sets of Buttons ie. ON and OFF or use the same Text ie. Button

Awesome Radiobuttons - make your choice between Dog, Cat or Other and store the result in a Defined Name

Awesome Radiobuttons - multiple sets of smaller Radiobuttons so that you can see how I Name the Shapes to distinguish between different Radiobutton Groups

Awesome Popup Buttons - hold the Mouse down on these little beauties to trigger Macros, before letting them spring back

Awesome Misc Popups and Checkboxes - demonstrations of changing the Icon size and colour as well as a Checkbox style of Button

Awesome Buttons on a Menubar using my Alternative Method Macros which allow you to Nest Grouped Buttons and Shapes and still use the Toggle Code

FAQ

There are no frequently asked questions for Awesome Buttons


Awesome Buttons

This is a video of the Awesome Buttons. Music Hackers by Metrik Get it Here

This is a video of the Awesome Buttons including the Text Buttons and the Radiobuttons. Music Hackers by Metrik Get it Here

This is a video of the Awesome Popup Buttons and Misc Sheet demonstrating changing the Icon sizes and colours, to create a Tick/Cross style Popup Button and Checkbox style Buttons. Music Hackers by Metrik Get it Here

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

* I would like to produce a Popup Button that runs a Macro upon a Mouse press and then after finishing, it 'Pops' the Button back up. This should not be too difficult an action to produce, so if anyone wants a go at doing this, please feel free to do so - if not I will add this in future updates to the Software...

Bug Fixes

* Radiobuttons: On toggling in and out of a higher Zoom, the Icon centers (blue dots) may not center correctly

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

05.07.2021

(Version 1.6) include the API for a Pause in milliseconds that may be required when you come to integrate the Popup Buttons into your own Projects. The subtle Pause allows the you to visibly see the change when a Popup Button is depressed as the Icon/background changes colour (if required) and gives a fantastic look and feel to the Button action

03.07.2021

(Version 1.5) the addition of 2 new Subroutines that can be linked to Buttons to enable Nested Groups of Buttons and Shapes ie. Buttons, a Menubar and Dividers. These 2 Subroutines provide the Macros to drive default Toggle Buttons and Popup Buttons and use the Macros, AltToggle() and AltPopupToggle(). I added an example Sheet, 'Awesome Buttons (Alt. Method)' to demonstrate a standalone Button that uses the technique and then Buttons that are Nested within multiple Grouped Shapes

30.06.2021

(Version 1.4) renamed the 'mdAwesoButtons' to 'mdAwesomeButtons'. Renamed some of the variables in the Popup and PopupToggle Subroutines that referred to the Radiobuttons Subroutine and made no sense. Renamed the 4 Rectangles on the 'RB Example2' Sheet and rearranged their order. Aligned the Radiobutton Shapes on the Sheets 'Example1' and 'Example2' for their Depressed State as they were slightly skewed but in doing so found a slight bug: On toggling in and out of a higher Zoom, the Icon centers (blue dots) may not center correctly

29.06.2021

(Version 1.3) added Awesome Popup Buttons to the Project so that a user can depress and hold the Mouse down on them, before releasing and letting them spring back to their initial setting. You can run Macros after pressing the Buttons. Also a Sheet called Misc is added demonstrating some other ideas for you to use with the Buttons including manipulating the Icon size and colours. There are some Checkbox style Popup Buttons with the Button Shadows removed and placed around the Icon itself

28.06.2021

(Version 1.2) added Awesome Radiobuttons to the Project so that a user can make a Selection from a variety of different options and you can store the result in a Defined Name. Examples incude using multiple Radiobutton sets on a Sheet

26.06.2021

(Version 1.1) added Rectangular Text Buttons to the Project. Renamed the Sheets and changed some of the Tips and Headers on the Example Sheets

24.06.2021

(Version 1) general release