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
---------------
Jacob Skaria


"Eddie_SP" wrote:

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?

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" wrote:

Do you mean

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

If this post helps click Yes
---------------
Jacob Skaria


"Eddie_SP" wrote:

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?

Cheers!

If this post helps click Yes
---------------
Jacob Skaria


"Eddie_SP" wrote:

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" wrote:

Do you mean

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

If this post helps click Yes
---------------
Jacob Skaria


"Eddie_SP" wrote:

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?