Good day,
Kind of just a general question. I am looking on the web for answers that has not yet suited my needs. I am looking for a method or information on a calendar control for my 2013 excel edition. I am working with Calendar Control from 2007 and I am aware that 2013 (well 2010 and up) has discontinued this method. Don't ask me why I thought it was great for my needs.

Any who, I am looking for a way to have a VBA calendar set up, I have a double click method in VB that, when I would double click a cell a calendar pop up would appear and I would select the date and it would go in my ActiveCell. This method was convenient as I did not had to insert any add-ins or download any content when working with different workbook in my network. Now with calendar control gone I need to figure a way that my general template (workbook) will not install but automatically have this function when I introduce this workbook to another user.

On top of this I need to be able to Control my Userform in separate ways that some textboxes will be individually controlled if I decide to have a (On Click, calendar.show) and insert it in the desired location.

The way I have it set up before was One Calendar Control (frmCalendar) was for anything in my sheets. I would just have to add:

    
If Not Intersect(Target, Range("")) Is Nothing Then
        frmCalendar.Show
        Cancel = True
    End If
And for my Userform:
Private Sub Calendar1_Click()
    frmne.TextBox3.Value = Format(Calendar1.Value, "yyyy/mm/dd")
    Unload Me
End Sub

Private Sub Calendar1_DateClick(ByVal DateClicked As Date)
   On Error Resume Next
   Texbox.Value = DateClicked
   Unload Me
End Sub

Private Sub cmdClose_Click()
    Unload Me
End Sub

Private Sub UserForm_Activate()
Me.Calendar1.Value = Date
End Sub
Now how would I go, without complicating things, to have a calendar control in my 2013 version of Excel to control my sheets and my userforms? On top of that to be able to be add-ons free without downloading content?

Downloading content is out of the question as we have a very thigh secure network that is admin controlled.

This need to work on Excel 2007 to 2013.

Any help, info or/and guidance would be helpful.

Thank you,

Excelnoub