VBA - Monthview working with textboxes

[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?

 

[Jacob Skaria]

Do you mean

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

If this post helps click Yes

 

[Eddie_SP]

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 !!!

 

[Jacob Skaria]

Cheers!

If this post helps click Yes