Rollover Sidebar Calendar

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
                            

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:
=CalendarDay

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
                            

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 should not be edited ie. Calendar Date, Calendar Year, Calendar Month, Calendar Day as these are used internally by the VBA Code

Month Selection Drop-down Combo

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

Highlighting the Calendar Days

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

New Date Selection

The Calendar with a new Date Selected:

Collapsing the Calendar

The Calendar in its Collapsed state:

Video of the Rollover Sidebar Calendar in action

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

There are currently no frequently asked questions about this Software that cannot be answered via this documentation