title: How to get date clicked on monthview to my textbox on userform?
body: <pre><code>Private Sub MonthView1_DateClick(ByVal DateClicked As Date)
  Txt_Prod_Loc_Date.Value = MonthView1.Value
  Unload Me
  End Sub
  
  Private Sub FrmCalendar_Initialize()
  Unload Me
  End Sub
  </code></pre>
  
  <p>I also tried Txt_Prod_Loc_Date.Value= DateClicked. But I see a " runtime error 424, object required</p>
  
  <p>Thanks</p>