| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calender does not desapear
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Calender does not desapear
Do you use the code from my site ?
-- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "maperalia" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Calender does not desapear
Yes I do..
"Ron de Bruin" wrote: Do you use the code from my site ? -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "maperalia" wrote in message ... 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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Calender does not desapear
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 -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "maperalia" wrote in message ... Yes I do.. "Ron de Bruin" wrote: Do you use the code from my site ? -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "maperalia" wrote in message ... 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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Calender does not desapear
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 de Bruin" wrote: 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 -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "maperalia" wrote in message ... Yes I do.. "Ron de Bruin" wrote: Do you use the code from my site ? -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "maperalia" wrote in message ... 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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Calender does not desapear
Hi maperalia You can find a link on my page where you can download the control and also instructions how to install it. http://www.rondebruin.nl/calendar.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "maperalia" wrote in message ... 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 de Bruin" wrote: 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 -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "maperalia" wrote in message ... Yes I do.. "Ron de Bruin" wrote: Do you use the code from my site ? -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "maperalia" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calender | Excel Discussion (Misc queries) | |||
| CALENDER | Excel Discussion (Misc queries) | |||
| Need help on formulas for calender | Excel Discussion (Misc queries) | |||
| Calender Help | Excel Worksheet Functions | |||
| Calender calculation | Excel Discussion (Misc queries) | |||
Hybrid Mode
