Logo Box

Purchase · £2.99

Introduction

Introducing LogoBox for Excel

Interactive, Draggable, Modal or Modeless 3D Style Logo Boxes to use in Excel 2016 (32bit or 64bit, Version 16) · Build Beautiful, Modern UserForms for Excel

Logo Box, Icon Box, Brand Box, call it what you like, but if you want an Interactive Dialog for a UserForm, featuring a Close Cross and an Icon (Optional Header and Strapline) with a really nice, modern look for Excel then how about using my Logo Box Software giving you the Code and methods to download Vector Images and change them into a sleek, different Boxes that you can 'Popup' to users. Logo Box use my minified Extensibility Class for Excel (redacted from my UserForm-Extensibility Class) to make some aspects of interactivity easier like adding a Hand Cursor to a Close Cross or allowing a UserForm or parts of a UserForm to be transparent and / or dragged by the Mouse. All of the Credits for Images are in the Download File together with links for Purchasing Vectors (where I have used Pro licenses myself) to enable you to develop this Software further should you so wish

You are purchasing Logo Box v1 which includes various examples of different Logo Box, the Extensibility Class, one-size '.BMP' Images and '.PNG' transparent Close Cross and Icons. You also get all of the designs in Blank format so you can add your own Logo/Icon/Brand images. More importantly, you get a method using my Code to download and create your very own alternative Logo Boxes should you want to


       

If you love Logo Box, you may also like any of the following Software. Boho MP3 Player uses UserForm Extensibility as the interface for all of its dialogs


DialogBox ·  Speech Bubbles ·  Info Bubble ·  Warning Msg ·  Info Msg ·  Question Msg ·  Error Msg ·  Userform Extensibility ·  Boho MP3 Player ·  Mint UserForm ·  Slate UserForm ·  Lightbox UserForm ·  Dark UI ·  Blue UI ·  Carbon UI ·  UserFOrm UI ·  BoX ·  Flat UI ·  UserForm Slider Buttons

Prerequisites

  • Microsoft Excel 2016 Version 16 (32bit or 64bit) · designed for Office 365 Windows 11
  • Basic to moderate Excel Skills and some basic VBA skills
  • Windows PC · NOT a Mac!
  • No support is provided for customization of this Software

Features

  • Self.RemoveCaptionBordersAndSetTransparency - remove the Caption, Borders from a UserForm and sets the Transparency so that you can use a .BMP and make the White parts transparent in Excel
  • Self.AllowDrag - creates a draggable UI Interface, move the UserForm (or other Controls on the UserForm) around with the Mouse
  • Use with both Modal or Modeless UserForms
  • Use the Escape Key {ESC} to exit
  • Interactive Close Cross - changes colour when the Mouse rolls over it and shows the Hand Cursor via the Extensibility Class
  • Header and Strapline Messages as Label Controls - Change the Text, Text Size, Weight and Colour of your LogoBox Header and Strapline Messages
  • Free Close Cross Icon in various Colours
  • Isolated, extracted and manipulated .BMP's (Bitmaps) that can now be loaded directly into a UserForm
  • Three folders, 'bmps', 'affinity' and 'transparent images' containing all of the images used in this Software
  • Blank versions of all of the LogoBoxes in 3 sizes are included so that you can then add your own Logo/Icon/Brand as required
  • Irregular UserForms with their Captions or Titlebars removed and containing images using a special Transparency Colour, ie. White, RGB(255, 255, 255), to hide parts that should be transparent
  • A lovely Curved Shaded 3D Border with the missing part set to White, RGB(255, 255, 255) so that the Transparency Key can be used to make them transparent when loaded into a UserForm







Installation

Right-click and extract the contents of the File LogoBox.zip. Original Affinity images are stored in the 'affinity' Folder, Bitmaps are stored in the 'bmps' Folder, Transparent .PNG's are stored in the 'transparent images' Folder. Open LogoBox.xlsm and test the Examples

To use Logo Box in your own Projects open LogoBox.xlsm and your own Macro-enabled Project. Then open the VBE (Visual Basic Editor) and drag the Extensibility Class and any of the UserForms into your Project. Add and configure any of the Example Code in the Examples Code Module to use each Logo Box

Take some time to examine how Logo Box works and read the 'Usage' Section in this online documentation before you begin to create your own Logo Boxes for Excel or before turning to Support


Usage

How to use Logo Box


What are LogoBoxes and How to Use them in Projects
LogoBoxes are Irregular UserForms with their Captions or Titlebars removed and containing images using a special Transparency Colour, ie. White, RGB(255, 255, 255), to hide parts that should be transparent. They can be used as a Modal Dialog or a Modeless Dialog depending on your requirements. They can be dismissed via the Escape '{ESC' Key or the Close Cross. To use Logo Box in your own Projects open LogoBox.xlsm and your own Macro-enabled Project. Then open the VBE (Visual Basic Editor) and drag the Extensibility Class and any of the UserForms into your Project. Add and configure any of the Example Code in the Examples Code Module to use each Logo Box

The Examples, LogoBox 1, Large, Medium and Small LogoBoxes in 3 Designs with an interactive Close Cross and Optional Headers/Straplines
The first few examples demonstrate the lightest design of LogoBox with White dominating the Foreground Colour in 3 different pixel sizes, 'Large := 400px', 'Medium := 350px' and 'Small := 300px'. All of the main LogoBox images are loaded directly into the UserForm. The Close Cross is animated via the Code to change the Colour and to add a Hand Cursor to the interactivity. One of the Close Crosses is '28px' used for the Large LogoBoxes, whereas the others are '22px' used for the Small LogoBoxes. You can choose to turn on the Header and Strapline Labels if required, this is up to you. All of these LogoBoxes are then also shown in a Blank form, so that you can add your own images that may be Logos/Icons/Brands

To display the first LogoBox UserForm in your own Excel Workbook simply use Code like this in any standard Code Module (you can uncomment both the Header and Strapline Code to use these Label Controls should you want to): 
' Large LogoBox
Public Sub Example1()
   With LogoBox1
      '.Header.Font.Bold = True
      '.Strapline.Font.Bold = True
      .Header.Caption = vbNullString
      '.Header.Caption = "Brand"
      .Strapline.Caption = vbNullString
      '.Strapline.Caption = "add your own Strapline if required"
      .Show 0
   End With
End Sub



The Examples, LogoBox 1, Small LogoBoxes with Icons and an interactive Close Cross and Optional Headers/Straplines
Next up I use the Small LogoBox to demonstrate adding your own Logo/Icon/Brand identiry. Here I add 3 Icons to the UserForm LogoBoxes, a Tick, a Padlock and a Cloud (Download). I changed the Close Cross Colour to match the Icon style. One of the Close Crosses is '28px' used for the Large LogoBoxes, whereas the others are '22px' used for the Small LogoBoxes. To display one of these in your Excel Workbook simply use Code like this in any standard Code Module: 
' Small LogoBox Blank with Padlock Icon
Public Sub Example7()
   With LogoBox7
      '.Header.Font.Bold = True
      '.Strapline.Font.Bold = True
      .Header.Caption = vbNullString
      '.Header.Caption = "Brand"
      .Strapline.Caption = vbNullString
      '.Strapline.Caption = "add your own Strapline"
      .Show 0
   End With
End Sub


Turning on the Headers and Strapline Labels
You can tell the UserForm that you want to use the Headers and Straplines via the Code used in the 'Examples' Code Module. You can also position the Labels, change the Font Style and Size and change the Label Foreground Colours. Here is the Code that switches on the Header and Strapline and changes the Font Colour: 
' Small LogoBox Blank with Tick Icon and visible Header & Strapline
Public Sub Example11()
   With LogoBox10
      .Header.ForeColor = 14142648
      .Header.Caption = "Success"
      .Strapline.ForeColor = 14142648
      .Strapline.Caption = "Well done you, you rock!"
      .Show 0
   End With
End Sub
 


Other Styles of LogoBoxes
There are 3 different styles of LogoBoxes in the Software. A light version using White for the Foreground, a Bright Blue version using Bright Blue for the Foreground and a dark version using Navy and Bright Blue combined. Test out the rest of the examples which demonstrate these different styles
   


Extensibility Class
The Extensibility Class is required for LogoBox to remove the Caption and Borders from a UserForm. It also allows the White colour to become transparent so that you can use irregular Window Sizes for the UserForm via .BMP's. It allows a number of simple ways to extend your UserForms, for example to make them (or any Control) draggable use the following Code: 
Option Explicit

Private Self As New Extensibility

' UserForm
Private Sub UserForm_Initialize()
   Set Self.Assign = Me
End Sub

Private Sub UserForm_MouseDown(ByVal Button As Integer, ByVal Shift As Integer, ByVal X As Single, ByVal Y As Single)
   Self.AllowDrag
End Sub
To show a hand Cursor use the following Code: 
Option Explicit

Private Self As New Extensibility

' UserForm
Private Sub UserForm_Initialize()
   Set Self.Assign = Me
End Sub

Private Sub Close_Cross_Active_MouseMove(ByVal Button As Integer, ByVal Shift As Integer, ByVal X As Single, ByVal Y As Single)
   Self.AddCursor IDC_HAND
End Sub
To remove the Caption, Borders and allow Transparency of White (a Long Colour Code) use the following Code: 
Option Explicit

Private Self As New Extensibility

' UserForm
Private Sub UserForm_Initialize()
   Set Self.Assign = Me
   Self.RemoveCaptionBordersAndSetTransparency 16777215  
End Sub

Modal or Modeless?
To change a LogoBox from a Modeless UserForm to a Modal UserFrom simply change the zero (0) after the Code '.Show' to a 1 like this: 
' Large Modal LogoBox
Public Sub Example1()
   With LogoBox1
      .Header.Caption = vbNullString
      .Strapline.Caption = vbNullString
      .Show 1
   End With
End Sub

Image Processes - Loading in a Bitmap to a UserForm or Control
An easy way of getting an image into a UserForm or one of its Controls is to load a '.BMP' (Bitmap) directly. Use the 'Picture' member to Browse and load the File. To create a Bitmap you can use Photoshop to take any Transparent Image saved as a '.PNG' and convert it by using 'Save As' into a Bitmap, choose Format 'BMP (*.BMP;*.RLE;*.DIB)', File Format 'Windows' and Depth '24 Bit'. Where you need to have the Background Colour a different Colour from standard White '255, 255, 255' for your Bitmap, because for example you are using White as the Transparent Colour, which would cause holes in your image, then use the Paint Bucket Tool, selecting an alternative Colour by entering the RGB Values ie. '254, 254, 254' together with settings, Opacity '100%', Tolerance '30' and tick the Anti Alias checkbox

Image Processes - Loading in a Transparent PNG to a UserForm or Control
A trick I use all of the time is to use my Free ImageTransparency.xlsm Software to load in a Transparent '.PNG' File into a UserForm or one of its Controls - you can download this free here. This technique allows you to load any PNG and then Paste it into the Picture memeber of the UserForm or Control. You MUST set the background Colour 'BackColor' of the UserForm or Control in the single UserForm within the ImageTransparency.xlsm File first and this should be a VB Hex Colour - use a great Tool like 'InstantEyeDropper' to do this, it's free and can be downloaded from here. Now press the 'Copy to Clipboard' Button in the ImageTransparency.xlsm Software to Browse and load in the PNG File. Switch to Excel and Paste into the Picture member. The PNG image will now be added to the UserForm or Control and the Transparent Colour will be replaced by the VB Hex Colour that you used for the BackColor of the UserFrom or Control

Screeen Shots (Small LogoBoxes are Featured however LogoBoxes come in 3 Sizes)

A Small LogoBox with a Tick Icon and an Interactive Close Cross

A Small LogoBox with a Padlock Icon and an Interactive Close Cross

A Small LogoBox with a Cloud Icon and an Interactive Close Cross

LogoBox design 1 with an Interactive Close Cross

 

LogoBox design 2 with an Interactive Close Cross

 

LogoBox design 3 with an Interactive Close Cross

 

LogoBoxes design 1

LogoBoxes design 2

LogoBoxes design 3



FAQ

* There are currently no FAQ for Logo Box



Logo Box Videos

This is a video of the Logo Box Software. Music is 'The Trapezist - Quincas Moreira'. View this 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

* I may chose to include '.EPS' and '.AI' image files with this Software

Bug Fixes

* There are currently no bugs identified for Logo Box

Changelog

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

12.03.2023 - (Version 1)

General release of Logo Box