Introduction

Introducing DialogBox for Excel

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

Dialog Box lets you create interactive 3D style Dialogs for a UserForm, featuring a Close Cross and an Icon (Optional Header and Strapline) with a really nice, modern look. Dialog Boxes come in 3 sizes, 'Small := 400px', 'Medium := 450px' and 'Large := 500px'. All of the images used have been converted from Vectors, via PNG and then Bitmap, with the final Bitmaps, touched up slightly using the RGB(254, 254, 254) value so as to work on any coloured Excel background with the White Colour RGB(255, 255, 255) used for the transparency key. My Software gives you the Code and method to download Vector Images and change them into a sleek, different Boxes that you can 'Popup' to users. Dialog 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 Dialog Box v1 which includes various examples of a couple of different Dialog Boxes, 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 Dialog Boxes should you want to


       

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


NeoGeo ·  About ·  Splash (Bauhaus) ·  Card ·  WebLabelDialog ·  RetroDialog ·  LogoBox ·  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 DialogBox 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
  • Two folders, 'bmps' and 'transparent images' containing the images used in this Software
  • Blank versions of all of the DialogBoxes 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 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
  • Overlay multiple Dialog Boxes

Fonts

The Font used throughout this Software in Excel is called 'Comfortaa'. It is sized at '22pt'for the Header and '12pt' for the Strapline. Please note: this Font will NOT follow the Workbook unlike Word Documents or PowerPoint Slides as Fonts cannot be easily embedded into Excel Workbooks. I also use the Font 'Cascadia Mono' which will follow the Workbook. You can either download and install the Comfortaa Font, Comfortaa Specimen on Google Fonts or change the Font to a standard Font like 'Calibri', 'Consolas' or 'Verdana' for example. You can also use any Font if you create the Text in images using Affinity Designer or Photoshop. There are a couple methods to embed Fonts within the Worksheet of a Workbook and I have Software called FontHeads that does just this, so that the Font follows the Workbook and is written out from within the Worksheet to a temporary File and then installed on the fly as the Workbook is opened each time. You can also use embedded Objects (True Type Fonts) in Excel to include Fonts in Excel and I have some free Software to demonstrate this technique here (enter the word Font in the 'Search for Project Name...' Box and a couple of Files will popup that you can download and try, the main one being Embedding Multiple Fonts.xlsb which include free Fonts, 'Ostrich.ttf', 'Pacifico.ttf', 'Caviar Dreams.ttf' and 'Blackjack.ttf'

Credits

Dialog Box Image Vector by Arfandri Ilham (sore-studios) purchased under a Vecteezy Free license. You can view and purchase the file here. Isolated low-res images, saved as a Bitmap and then loaded directly into the UserForm. Please note: the original Vector is NOT included with this Software, only modified 'lower' resolution parts are used for loading into the Excel UserForm and / or image Controls

Outline Icons (Futicons) by Vaisakh Pradeep. You can view and download the file here. This work is released under a Creative Commons license

Delivery Icons by Roxana Carabas from EpicPxls. You can view and download the file here

Retro Background for Excel by neobianca007, downloaded under a Pro License one-size, modified colour-wise to match the Bauhaus Vector used for this Project, reduced and embedded into Excel, not for backward dissasembly). Please note: regardless of the license, no attempt should be made to extract this image. You can view and purchase the file here

Close Cross taken from a Retro Information Dialog Box by ulyanamo (Ульяна Москальчук), downloaded under a Pro License (isolated, one-size .PNG copies only to load into Image Controls and create the interaction via VBA Code). You can view and purchase the file here

Extensibility Class, UserForm Enabler for Interactivity by Mark Kubiszyn redacted from UserForm Extensibility for Excel



Installation

Right-click and extract the contents of the File DialogBox.zip. Bitmaps are stored in the 'bmps' Folder and Transparent .PNG's are stored in the 'transparent images' Folder. I have also included a File called 'DialogBox_Comfortaa.xlsm' which has an embedded Font Object to allow the 'Comfortaa' Font to follow the Workbook - see the Fonts Section. Open DialogBox.xlsm and test the Examples

To use Dialog Box in your own Projects open DialogBox.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 Dialog Box

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


Usage

How to use Dialog Box


What are DialogBoxes and How to Use them in Projects
DialogBoxes 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 Dialog Box in your own Projects open DialogBox.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 Dialog Box

DialogBox1: Demonstrations of various styles of DialogBoxes as taken from the Vector with Logo/Branding Text (Headers & Straplines Optional)
The first six examples demonstrate the dark Navy design of DialogBox in 3 different pixel sizes, 'Small := 400px', 'Medium := 450px' and 'Large := 500px'. All of the main DialogBox images were taken from the original Vector, converted to transparent '.PNG' and then reloaded and saved again as '.BMP' (Bitmaps). These are then loaded directly into the UserForm via the 'Picture' member. The Close Cross is animated via the Code to change the Colour and to add a Hand Cursor to the interactivity. The Close Crosses are all '22px'. The Close Crosses are loaded via my 'ImageTransparency.xlsm' Software with the background Colour set to the same Colour as the Colour of the DialogBox ie. RGB(254, 254, 254) which changes the '.PNG' transparency Colour into this RGB Colour. I have also included Header and Strapline Label Controls. You can choose to turn on the Header and Strapline Labels and add any Text that you want, if required, this is up to you and the last 3 examples demonstrate both the Header and Straplines using various Text

To display the first DialogBox 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):
Public Sub Example1()
   With DialogBox1
      '.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

 

DialogBox1: Blank DialogBoxes to use with your own Icons/Logos/Brands
Next I switch off the Branding and Text to leave just the DialogBox and create 3 DialogBoxes that you can add your own images to that may be Logos/Icons/Brands and use in your own Projects. All of these Dialog Boxes will look perfect over any Excel background as I have made tweaks to the final images to ensure the White Transparency Colour is fully replaced by the Code so that the Borders of the image float in pixel-perfect happiness! Check them out:

   

Adding Different Icons
For the next set of 3 examples I used some Outlined '.SVG' Icons and converted them into Transparent '.PNG' images at a size of '96px'. I then used my ImageTransparency.xlsm Software to load these into the Icon Image Controls setting the background Colour of the Software to Navy so that the Transparent pasrt is replaced by the Navy and they float nicely on the UserForm. I made some tweaks to the Strapline by moving it about and changing the Text. I used 3 Icons, a 'Chip' Icon, a 'Bitcoin' Icon and a Sustainability Green Trees' Icon (it is still displayed in RGB(254, 254, 254) to match the Close Cross Colour. I think they look pretty effective. Check them out:

   


A White DialogBox
I wanted another DialogBox to use but in White so I have designed a single-sized '400px' DialogBoxwith a White background and a thin Grey Border. I then added a cute Stop Icon. Here is the final DialogBox on a Blue background:

 


Extensibility Class
The Extensibility Class is required for DialogBox 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 DialogBox from a Modeless UserForm to a Modal UserFrom simply change the zero (0) after the Code '.Show' to a 1 like this:
Public Sub Example1()
   With DialogBox1
      .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 member 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

Image Processes - Another Method to Load an Image into a Control
You can load in a transparent 'PNG' image into Affinity and add a Layer that is a Rectangle and set it to the background Colour you want it to have once it is loaded. Export out that image as a '.PNG' image again. Now load it into Photoshop and Save it as a '.BMP' image. Finally load this Bitmap directly into any Image Control and it will sit ontop of the background and appear to blend in perfectly - I demonstrate this in the DialogBox2 that uses the 'Stop' Icon

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

DialogBox 1, a dark Blue Box with Branding and Text. The Dialog Boxes all include an interactive Close Cross. This is an example of what you may achieve and is included alongside all of the Blank Dialog Boxes

 

DialogBox 1, a dark Blue Box with Branding, Text and Optional Header and Strapline. The Dialog Boxes all include an interactive Close Cross. This is an example of what you may achieve and is included alongside all of the Blank Dialog Boxes

 

DialogBox 1, a dark Blue Box with a Sustainability Green Trees Icon, Header and Strapline. The Dialog Boxes all include an interactive Close Cross

 

DialogBox2, a White Box, with a Cute Stop Icon The Dialog Boxes all include an interactive Close Cross

 

A Small DialogBox to use in your own Projects

 

A Medium DialogBox to use in your own Projects

 

A Large DialogBox to use in your own Projects

A DialogBox with a Chip Icon

 

A DialogBox with a Bitcoin Icon

 

A DialogBox with a Sustainability Green Trees Icon

Multiple Dialog Boxes ontop of a regular Excel Worksheet



FAQ

* There are currently no FAQ for DialogBox




DialogBox Videos

This is a video of the DialogBox Software. Music is 'The Trapezist - Quincas Moreira'. View this video on YouTube



Support

Support is 100% optional and I provide it for your convenience, so please be patient, polite and respectful

Support for my Software

  • 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
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. 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 DialogBox

Fonts


Fonts

The Font used throughout this Software in Excel is called 'Comfortaa'. It is sized at '22pt'for the Header and '12pt' for the Strapline. Please note: this Font will NOT follow the Workbook unlike Word Documents or PowerPoint Slides as Fonts cannot be easily embedded into Excel Workbooks. I also use the Font 'Cascadia Mono' which will follow the Workbook. You can either download and install the Comfortaa Font, Comfortaa Specimen on Google Fonts or change the Font to a standard Font like 'Calibri', 'Consolas' or 'Verdana' for example. You can also use any Font if you create the Text in images using Affinity Designer or Photoshop. There are a couple methods to embed Fonts within the Worksheet of a Workbook and I have Software called FontHeads that does just this, so that the Font follows the Workbook and is written out from within the Worksheet to a temporary File and then installed on the fly as the Workbook is opened each time. You can also use embedded Objects (True Type Fonts) in Excel to include Fonts in Excel and I have some free Software to demonstrate this technique here (enter the word Font in the 'Search for Project Name...' Box and a couple of Files will popup that you can download and try, the main one being Embedding Multiple Fonts.xlsb which include free Fonts, 'Ostrich.ttf', 'Pacifico.ttf', 'Caviar Dreams.ttf' and 'Blackjack.ttf'

Credits

Credits

Dialog Box Image Vector by Arfandri Ilham (sore-studios) purchased under a Vecteezy Free license. You can view and purchase the file here. Isolated low-res images, saved as a Bitmap and then loaded directly into the UserForm. Please note: the original Vector is NOT included with this Software, only modified 'lower' resolution parts are used for loading into the Excel UserForm and / or image Controls

Outline Icons (Futicons) by Vaisakh Pradeep. You can view and download the file here. This work is released under a Creative Commons license

Delivery Icons by Roxana Carabas from EpicPxls. You can view and download the file here

Retro Background for Excel by neobianca007, downloaded under a Pro License one-size, modified colour-wise to match the Bauhaus Vector used for this Project, reduced and embedded into Excel, not for backward dissasembly). Please note: regardless of the license, no attempt should be made to extract this image. You can view and purchase the file here

Close Cross taken from a Retro Information Dialog Box by ulyanamo (Ульяна Москальчук), downloaded under a Pro License (isolated, one-size .PNG copies only to load into Image Controls and create the interaction via VBA Code). You can view and purchase the file here

Extensibility Class, UserForm Enabler for Interactivity by Mark Kubiszyn redacted from UserForm Extensibility for Excel

Changelog

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

14.03.2023 - (Version 1)

General release of DialogBox