title: How can we use datepicker without MSCOMCT2.OCX file?
body: <p>I developed an Excel application to work out staff absences.<br />
  I created a userform (calendar) that works as a date picker to specify a date in the cell (“I32”).</p>
  <p>To make that work at home, I downloaded the MSCOMCT2.OCX and paste that OCX in system32 to register.</p>
  <p>At the office the userform does not work as the office does not have the option of Microsoft MonthView control.<br />
  I tried to copy the MSCOMCT2.OCX for registering. The system does not allow me to do so without the administrator password.</p>
  <p>How can I bypass the MSCOMCT2.OCX?</p>
  <pre class="lang-vb prettyprint-override"><code>Private Sub Worksheet_SelectionChange(ByVal Target As Range)
       
      If Not Intersect(Target, Range(&quot;I2&quot;)) Is Nothing Then Calendar.Show
       
      If Target.Column = 3 Or Target.Column = 4 Or Target.Column = 5 Or Target.Column = 6 Or Target.Column = 7 Then
          If Target.Row = 14 Or Target.Row = 24 Or Target.Row = 34 Or Target.Row = 44 Then
              Beep
              Cells(Target.Row, Target.Column).Offset(0, 1).Select
          End If
       End If
      
  End Sub
  </code></pre>