Geek Documentation Logo

RadiObuttons

Version 1


Introduction


If you have already purchased this Software, let me take a moment to thank you for being a loyal customer
You are entitled to free lifetime updates for ALL future builds

This documentation is to help you understand the Software and to give you a more meaningful insight into what it can do. Please go through the documentation and read it carefully · Basic Excel and some VBA skills will be required

Requirements

You will need the following Excel Version & Prerequisite to use this Software

  1. Excel 2010, 2013 & 2016 (32bit or 64bit)
  2. Basic Excel and some VBA skills
  3. Windows PC · NOT a Mac!

No support is provided for customization or development of this Software






About RadiObuttons #back to top

RadiObuttons are lovely little animated Radiobuttons for Excel made from 2 Shapes, a Radiobutton and a Circle or Tick. Both Shapes have a Macro assigned. When a Radiobutton is clicked the animation fades in another Circle or Tick Shape to identify it as being Selected. If required you can have a Blank set of Radiobuttons with no Radiobutton being Selected and if so, the Radiobutton runs another animation to remove the Selected Radiobutton

You can duplicate and/or add the Code and Shapes very easily into a new or existing Project and capture which Radiobutton is Selected for any Radiobutton Group. Here is a Screen Shot of the available Radiobuttons with different Styles:

RadiObuttons Buttons Image

Features include:

  • * Aesthetically pleasing with a lovely smooth animation upon a Radiobutton Click
  • * Easily add to your own Projects
  • * Capture which Radiobutton is currently Selected using VBA
  • * Use your own Icons or Images
  • * Change the animation frame speed
  • * Use Styles to add Shadows or Glow
  • * Allow all of the Radiobuttons to be Deselected or force at least one of the Radiobuttons to be Selected (default)
  • * Change the Colour and Thickness of the Line animation for a deselected Radiobutton (Selected and then Clicked again to Deselect)







The Download File #back to top

The download File

Open the RadiObuttons.xlsm File. A License Worksheet is included in the Workbook. Select the "RadiObutton" Worksheet. Here you will find 6 separate Groups of Radiobuttons to test in various Styles. Click on each Radiobutton Group to test the Buttons. Press ALT+F8 and run the 'TestAllRadiobuttonsForGroupD()' Macro to see which Radiobutton is Selected in Group "D". You should see a Message informing you that 'Dradiobutton18' is Selected and the Item it relates to ie. 'Opening (default) Press ALT+F11 to enter the VBA Editor. Scroll down and view the Code used for the Radiobuttons. Before continuing, it is advised to take a Backup as you will no doubt want to Copy Checkboxes and Code from this Workbook

The Radiobutton Macro #back to top

The Shape use for the Radiobutton is linked to the main 'RadiobuttonClick()' Macro. This Macro enables the animation from a Deselected Radiobutton to a Selected Radiobutton. The 'Tick' Macro is called here and it takes 2 Parameters, the Name of the Shape (I use Application.Caller) and an Optional FrameSpeed (default is 0#). You can react here to the click if you want to and if so, add your own Code. Please Note: you should change these Public Macros to Private Macros using the 'Private' prefix as calling them via ALT+F8 will result in an error - it's up to you, I left them as Public so that you can link more Checkboxes if required. You could of course replicate this Macro and change it to your own Code, just remember to set the 'IsRunning' Boolean variable to True after an initial check and Exit if it is already True to prevent multiple Mouse clicks

' RadiobuttonClick, handles all clicks and animation
Public Sub RadiobuttonClick()

    ' prevent multiple clicks
    If IsRunning Then Exit Sub
    IsRunning = True

    ' perform Tick animation
    Tick AnimationShape:=ActiveSheet.Shapes(Application.Caller), _
         FrameSpeed:=0.03

    IsRunning = False

End Sub
                            

The Circle or Tick Macro #back to top

The Shape use for the Circle or Tick to display a Selected Radiobutton is linked to the 'TickClick()' Macro. This Macro enables the animation from Circle or Tick back to a Radiobutton BUT only for when you may want to allow all Radiobuttons to be Deselected. The 'Radiobutton' Macro is called here and it takes 4 Parameters, the Name of the Shape (I use Application.Caller), an Optional FrameSpeed (I use 0.06), an Optional LineColour and an Optional LineWeight value. You can react here to the click if you want to and if so, again, add your own Code. Please Note: you should change these Public Macros to Private Macros using the 'Private' prefix as calling them via ALT+F8 will result in an error - it's up to you, I left them as Public so that you can link more Checkboxes if required. You could of course replictae this Macro and change it to your own Code, just remember to set the 'IsRunning' Boolean variable to True after an initial check and Exit if it is already True to prevent multiple Mouse clicks

' TickClick, the one and only Tick Subroutine.  handles all clicks and animation
Public Sub TickClick()

    ' prevent an empty Radiobutton Group ie. no Radiobuttons Selected
    If InStr(1, RadioButtonGroups, Left(Application.Caller, 1), vbTextCompare) > 0 Then Exit Sub

    ' prevent multiple clicks
    If IsRunning Then Exit Sub
    IsRunning = True

    ' perform Radiobutton animation
    Radiobutton AnimationShape:=ActiveSheet.Shapes(Application.Caller), _
                FrameSpeed:=0.06, _
                LineColour:=RGB(120, 40, 58)

    IsRunning = False

End Sub
                            

The Radiobutton Shape #back to top

The Radiobutton Shape is a Shape with an Image of a small Circle. It is a transparent PNG Image. It is also where you should link your 'RadiobuttonClick()' Macro ie. right-click on Shape and choose Assign Macro... (make sure the Worksheet Protection is removed first). To view the Shape and change the Formatting or Image, right-click on a Shape and use the Selection Pane on the Arrange Group of the PAGE LAYOUT Tab of the Ribbon. Right-Click and then choose 'Format Picture...' Use the Paint Pot Tab to choose a File or Pattern

The RadiObutton Shape

Right Click on Radiobutton Shape

The Circle or Tick Shape #back to top

The Circle or Tick Shape is the Radiobutton's Selected Image, usually a Circle with a smaller inner Circle, but it can be any Image you like. It is a transparent PNG Image. It is also where you should link your 'TickClick()' Macro ie. right-click on Shape and choose Assign Macro... (make sure the Worksheet Protection is removed first). To view the Shape and change the Formatting or Image, right-click on a Shape and use the Selection Pane on the Arrange Group of the PAGE LAYOUT Tab of the Ribbon. Right-Click and then choose 'Format Picture...' Use the Paint Pot Tab to choose a File or Pattern

The Selected RadiObutton Shape

Right Click on the Selected Radiobutton Shape

Preventing Radiobutton Deselect #back to top

You will want to prevent a user from Deselecting a Radiobutton by Clicing on the same Button again. To do this press ALT+F11 and enter the VBA Code Editor. At the top of the Code Module you will find the following Code - simply add your new Radiobutton Group prefix ie. 'X' to this Variable

Option Explicit

' - AllowEmptyRadioButtonGroups, used to allow you to have a Radiobutton Group that can have no Radiobuttons Selected.  Just add the letters A-Z
Const RadioButtonGroups As String = "BDEFGH"
                            

Adding Style #back to top

You can add some nice effects to the Radiobutton Shapes to make them stand out more or 'jazz' up the Circle or Tick for the Selected Radiobutton Image. For example to add a Drop Shadow, right-click on an Image and on the WordArt Styles Group of the DRAWING TOOLS Tab on the Ribbon, select Text Effects->Shadow->Outer (pick the Shadow that you want) - you can also do this on the Picture Styles Group of the PICTURE TOOLS Tab on the Ribbon. Here is an image of some lovely Styles I have applied - these are in the File available for purchase

Radiobutton Styles

Changing the Style of the Radiobutton Shape

Radiobutton Groups & Radiobutton Naming Conventions #back to top

Radiobutton Groups are determined by using a prefix fro each Group as the Name for the Radiobutton and Circle or Tick Shapes ie. 'Aradiobutton10', 'Atick10', 'Aradiobutton11', 'Atick11' etc. This way the Code can differentiate each separate Radiobutton Group. You have a maximum 26 Groups made up of the letters 'A-Z'. To prevent a user Deselecting the Radiobutton by clicking the same Radiobutton you will need to include this Sufix in a Constant Variable at the top of the Code Module. To do this press ALT+F11 and enter the VBA Code Editor. At the top of the Code Module you will find the following Code - simply add your new Radiobutton Group prefix ie. 'X' to this Variable. The numbers for each Radiobutton serve to identify a unique individual Radiobutton, so you should always stagger these numbers - you have a maximum of 90 Radiobuttons without any Code modification

Radiobutton Groups and Naming Conventions

Limitations #back to top

The Code is limited to 100 Radiobuttons and Circles or Ticks and 26 Radiobutton Groups without modification

Screen Shots #back to top

The RadiObutton Workbook

This is a Screen Shot of the RadiObutton available for Purchase. You can see all of the different Radiobutton Groups with various Styling

RadiObuttons Image 1000px x 654px




Videos #back to top

Video of the Radiobuttons in Action

Here I run through the Radiobutton Groups testing the animations






Can I copy the Radiobuttons?

Yes just select 4 Shapes (4 separate Images or Shapes) and use Copy & Paste. Then rename the Shapes with a prefix for the new Radiobutton Group ie. 'X' and the next 2 new numbers ie. 41, 42 so you would end up with 'Xradiobutton41', 'Xtick41' and 'Xradiobutton42', 'Xtick42'. Then the Code will work for the extra Radiobuttons - the 'X' will identify them as a brand new Radiobutton Group






Support #back to top

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, please...

* Make sure your question is a valid Software Issue and not a customization request
* Make sure you have read through the documentation and any related video guides before asking support on how to accomplish a task
* Make sure to double check the Software FAQs or online documentation
* 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
Contact Kubiszyn.co.uk via our Facebook Page - remember to be patient, if there has been an issue with your download, I will always respond within 48 hours and will Email you the File directly if neccessary or via Messanger. 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

Version History (Changelog) #back to top

You can find the version history in the Code Module for any Macro-enabled Software or read more information below. The latest Version is always shown first


Changelog

05.11.2018 (Version 1) - Released