VBA - Monthview working with textboxes

's Computer Specifications

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?

's Computer Specifications

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?

's Computer Specifications

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?

's Computer Specifications

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?

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How do i get a MonthView or DatePicker object in my VBA toolbox?	Javelin52	Microsoft Excel Programming	0	10th Mar 2009 06:58 AM
Need MonthView controls help	=?Utf-8?B?YWxpcHM0aG0=?=	Microsoft Access Forms	0	15th Feb 2005 04:51 PM
Add link to Monthview Control value???	Targa	Microsoft Frontpage	0	24th Nov 2004 01:28 AM
Monthview AxtiveX	=?Utf-8?B?QUFJ?=	Microsoft Excel Programming	1	18th Apr 2004 04:49 PM
making monthview control visible only when cell is clicked	Colin Raven	Microsoft Excel Discussion	9	4th Apr 2004 04:38 PM