How To

How to Animate a UserForm with Easing and Fade by Mark Kubiszyn

A brief outline of this Project and what is in the purchased file

This Excel File will show you how to animate a standard UserForm with easing and a subtle fade. This project demonstrates fading in a UserForm as it animates into view horizontally from the Application left-hand side until the Application middle. Once it is dismissed the UserForm is animated out to the right-hand side of the Application edge disappearing as it fades. The Animation is very smooth using 2 easing functions, 1 for the 'easeIn' and one for the 'easeOut' (check out the video below). The code can be added for a Modal or Modeless UserForm. All of the code is in the UserForm Code Module itself and can be initialised by a simple call like this:

Public Sub Example()

   With UserForm1
      .Show 0 '1
   End With

End Sub


Prerequisites

  • 64bit Excel Version 16, for Office 365 (API's are included for both 32bit and 64bit)
  • Basic Excel and VBA skills to Copy the code into your own projects
  • Windows PC · NOT a Mac!
  • No support is provided for customization of this Software

Features

  • A single UserForm Code Module with one example
  • 2 easing Functions for the animation
  • Fade in and out code
  • easeInOutSine
    easeBackInQuartic
    

Video

This is a video of the How to Animate a UserForm

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

Changelog

You can find the version history below - the latest Version including a description of any changes made is always shown first:

16.10.2021 - (Version 1) Released

General release of How to Animate a UserForm with Easing and Fade