Calender does not desapear

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I inserted a calender option in the cell "C12". It is working very good,
however, the calender does not desapear it is there all the time. I just want
the calender to appear when the cell "C12" is selected. Also, I would like to
calender desapear as soon the date is selected (without pressing enter).
Thanks in advance.
Maperalia
 
You can add one line

Private Sub Calendar1_Click()
ActiveCell.Value = CDbl(Calendar1.Value)
ActiveCell.NumberFormat = "mm/dd/yyyy"
ActiveCell.Select
Calendar1.Visible = False
End Sub
 
Ron;
Thanks very much it is working perfectly!!.
However, I found that when I use it in another computer I have the following
error message:
Run-Time error ‘424’
Object Required
So, I went to Insert/Object at the tools menu and I found that the calendar
is not there.
In addition, I check that Microsoft Access is installed. So and do not how
to get the calendar now. Could you please tell me how to get the calendar?

Thanks in advance.
Maperalia
 
Ron;
I downloaded the program you have in your web. However, I got the the
following message when I open it:
Could not open because the object is not in this machine.
So, how can I load the calender object in this machine?

Thanks.
Maperalia
 
Peo;
Thanks veru much I followed the instructions and and it is working
perfectly!!!.

Thanks again.
Maperalia
 
Back
Top