Quick Steps

Rollover Sidebar Calendar documentation

2 Simple Steps to start using the Calendar

  1. Start a Project from scratch using the Rollover Sidebar Calendar Workbook that you purchased and edit the Calendar Settings on the "System" Worksheet
  2. Use the Defined Name '=CalendarDay' or VBA to capture a Selected Date (see the System Worksheet Code Module 'Worksheet_Change' Event Handler)


Rollover Sidebar Calendar was written by Mark Kubiszyn

  • the latest version is version 1
  • as per terms of the Software License, you should leave the following code attribution in situ

' © Copyright/Author:
' Mark Kubiszyn 2012-2017. All Rights Reserved
' Website/Follow:
' http://www.kubiszyn.co.uk/
' https://www.facebook.com/Kubiszyn.co.uk/


You can Purchase Rollover Sidebar Calendar for £2.99 via FastSpring by clicking here

Calendar Settings

Configuring the Calendar is straightforward. Here are the available options:

Calendar Month Format			mmmm yyyy	change this to how you want to see the Month displayed ie. 'October 2017'
Calendar Start Day			Monday		change this to either 'Monday' or 'Sunday'
Fade Calendar on Refresh		TRUE		change this to TRUE to fade the Calendar or FALSE to ignore the Setting
Set Calendar to Today on Opening	TRUE		change this to TRUE to set the Date as Today when opening or FALSE to ignore the Setting
Capture a Click on a Date using VBA	FALSE		change this to TRUE to Capture a Date using VBA or FALSE to ignore the Setting


Capturing the Date by the Defined Name

You can Capture the current Selected Calendar Date using the CalendarDay Defined Name like this:

In any Cell (not in-line with the Calendar Rows) add the following:

You can Format the Cell to display the Date exactly how you want
A Custom Format of dddd, dd mmmm yyyy will display the Date like this:
Wednesday, 11 October 2017


Capturing the Date using VBA

You can Capture the current Selected Calendar Date using VBA. Press ALT+F11 to enter the VBA Editor

Double-click on the Sheet2, System Worksheet Code Module - here you will find the Worksheet_Change Event Handler. I have added a simple MsgBox to display the Date. You can Call your VBA routine from here - I have added a Subroutine called 'Test' to another Code Module and Call it from the Subroutine below:

' // capture a Date on the Calendar if the Option is selected on the "System" Worksheet
Private Sub Worksheet_Change(ByVal Target As Range)

    If [CaptureClickOnDate] And Not Intersect(Target, [CalendarDay]) Is Nothing Then
        MsgBox [CalendarDay]

        ' // Call a VBA Subroutine from here
        Call Test
    End If

End Sub


And in another Code Module here is my 'Test' Subroutine where I set Cell "L11" to the Selected Date - obviously, you may want to do something other than just this:

Option Explicit

Sub Test()

 Range("L11").Value2 = [CalendarDay]

End Sub


Other Settings

Other settings should not be edited ie. Calendar Date, Calendar Year, Calendar Month, Calendar Day as these are used internally by the VBA Code

Screen Shots

The Calendar detailing the Month Selection Drop-down Combo used to Select a Month from 1 Year backwards or 1 Year Forwards:

Rollover Sidebar Calendar Month Select

The Calendar in the process of being highlighted by the Mouse using the Rollover technique:

Rollover Sidebar Calendar Rolled Over

The Calendar with a new Date Selected:

Rollover Sidebar Calendar Date Selected

The Calendar in its Collapsed state:

Rollover Sidebar Calendar Collapsed


Rollover Sidebar Calendar Demo (Today in the Video was Wednesday 11th October 2017 - when the Video was made):


Support is only given to Purchased Software. You should only contact me on the Support Email address supplied by FastSpring - please provide proof of purchase ie. Email address or Order Reference


14.10.2017 - Version 1 released. Standard Rollover Calendar with Fade Text routine, Month Drop-down Combo Select and ability to Capture the Date using a Defined Name or VBA Subroutine