Hello Everyone,

I have created a userform that displays the Calendar so that when I click on
it, it will input the date in a Active Cell.
Private Sub Calendar1_Click()
ActiveCell = Calendar1.Value
End Sub

Now, my question is: I don't want to put the date that I click on in an
Active Cell, that works fine. I want to be able to put the date in another
userform. I have another userform that requires a date entry: date1 How
do I click on my calendar and have it go to the Textbox (date1) in my other
Userform??? Is this possible??

Thanks.. mv

Private Sub Calendar1_Click()
Userform2.Textbox.Text = Format(Calendar1.Value,"dd mmm yyyy")
End Sub

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Michael Vaughan" wrote in message
...
Hello Everyone,

I have created a userform that displays the Calendar so that when I click
on
it, it will input the date in a Active Cell.
Private Sub Calendar1_Click()
ActiveCell = Calendar1.Value
End Sub

Now, my question is: I don't want to put the date that I click on in an
Active Cell, that works fine. I want to be able to put the date in
another
userform. I have another userform that requires a date entry: date1
How
do I click on my calendar and have it go to the Textbox (date1) in my
other
Userform??? Is this possible??

Thanks.. mv

Bob Phillips Wrote:
Private Sub Calendar1_Click()
Userform2.Textbox.Text = Format(Calendar1.Value,"dd mmm yyyy")
End Sub

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Michael Vaughan" wrote in message
...
Hello Everyone,

I have created a userform that displays the Calendar so that when I
click
on
it, it will input the date in a Active Cell.
Private Sub Calendar1_Click()
ActiveCell = Calendar1.Value
End Sub

Now, my question is: I don't want to put the date that I click on in
an
Active Cell, that works fine. I want to be able to put the date in
another
userform. I have another userform that requires a date entry:
date1
How
do I click on my calendar and have it go to the Textbox (date1) in
my
other
Userform??? Is this possible??

Thanks.. mv


If I want to add two date value in two different message box, How can I
do it?
suppose one is purchase date in textbox1.text and selling date in
textbox2.text
is there any way?


--
metsoftbaby
------------------------------------------------------------------------
metsoftbaby's Profile: http://www.excelforum.com/member.php...o&userid=27601
View this thread: http://www.excelforum.com/showthread...hreadid=274788