VBA - Monthview working with textboxes

  • Thread starter Thread starter Eddie_SP
  • Start date Start date
E

Eddie_SP

I have an UserForm with one Textbox and one Monthview standard calendar.

When I click on a date, I need this date to be shown on this Textbox and
only later I will confirm that date to be insert in a cell by clicking on a
CommandButton.

Can someone help me with that, please?
 
Do you mean

Private Sub Calendar1_Click()
TextBox1.Text = Calendar1.Value
End Sub

If this post helps click Yes
 
Hi Jacob !
First of all, thank you !

Instead of "Calendar1", I changed to "MonthView1", so it finally solved my
problem !

Private Sub MonthView1_DateClick(ByVal DateClicked As Date)
TextBox1.Text = MonthView1.Value
End Sub

Thank you once again !!!
 
Back
Top