Geek Documentation Logo

Spin

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 to Moderate skills are required

Requirements

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

  1. Excel 2016/2019, Version 16.0 (64bit only!)
  2. Basic Excel skills. Basic to moderate VBA Skills
  3. Windows PC · NOT a Mac!

Please Note: No support is provided for customization or development of this Software

About Spin #back to top

Spin is a configurable HTML/CSS/Javascript animation that fades in and out, designed to be displayed whilst running a Task in Excel Version 16.0. It is based arouond the Markup Code by Felix Gnass and has been rewritten from my old Preloader Code. It is much more lightweight than Preloader and runs smoothly. Spin has 3 Calls, Init(), Go() and Kill(). Spin has been specifically designed for Excel 2016/2019, Version 16.0 (64bit only). If you are running an older Excel Version or a 32bit Version you can download my original Preloader here

Spin Image

Features include:

  • * 3 Calls, Init(), Go() and Kill()
  • * Quick, smooth configurable animation
  • * Drag n Drop the UserForm into your Project, Copy a Subroutine and Spin is ready for use
  • * Change the Message displayed in real-time

Getting Started #back to top

The download File

Spin_v1.XLSM is ready to use. Open the Workbook and test the 3 Demos. To view the Code behind the Spin Demo, click 'View Code'

Using Spin #back to top

Spin is super-easy to use. To run Spin all you need are the following 3 Calls with whatever Task you are doing placed after the Call to Spin.Go:

Spin.Init

Spin.Go

' your task goes here with DoEvents added in your Code 
DummyTask 2500
   
Spin.Kill

Obviously Spin has a lot of configurable Optional Parameters - here are all of the allowed Optional Named Arguments for each Call (you can play around with these to tweak the Preloader that Spin displays):

Spin.Init Width:=132, Height:=78, Message:="Please wait..."

Spin.Go FadeinDuration:=1000, Colour:=Pumice, Lines:=7, LineLength:=1, LineWidth:=19, LineColour:=White, InnerCircleRadius:=21, CornerRoundness:=1, Speed:=1.4, Trail:=30

Spin.Kill FadeoutDuration:=600

Due to the fact that Spin is essentially a UserForm, you can take advantage of this through the Spin.Caption member to update the Dialog Message whilst Spin is running. For example you can do the following to update the user of whereabouts you are in some process as you loop through the Worksheet Rows like this:

Private Sub CaptionDemo()
   Spin.Init Message:=""
   Spin.Go
   
   Dim i As Long
   Dim SelectedCell As Range
   Dim SelectedSheet As Worksheet
   Set SelectedSheet = ActiveWorkbook.Sheets.Add(After:=Sheet1)
   For Each SelectedCell In SelectedSheet.Range("A1:A500").Cells
      i = i + 1
      SelectedCell.Activate
      DoEvents
      SelectedCell.Value = i
      DoEvents
      SelectedCell.Offset(0, 1).Value = Int((2 ^ 16 - 2 ^ 1) * Rnd() + 2 ^ 1)
      Spin.Caption = "Working Row: " & i
   Next SelectedCell
   Application.DisplayAlerts = False
   SelectedSheet.Delete
   Application.DisplayAlerts = True
    
   Spin.Kill
End Sub
Spin Caption Screen Shot

Screen Shots #back to top

Spin Demo

Spin Demo Screen Shot

There are currently no frequently asked questions about Spin

Videos #back to top

Video of Spin

Here I run the 3 Demos that ship with the Spin Software

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

12.10.2019 - (Version 1) release