| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calendar drop down
OK. Everybody refers to Ron de Bruin for how this is done. I do it...a
calendar appears and that's it. I can't make a selection, I can't get rid of the calendar even if I click on another cell. What am I doing wrong? Thanks. -- Rich D Armstrong Custom Homes Redmond |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Calendar drop down
Hi Rich
Which Excel version ? I think you are in Edit mode -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Rich D" wrote in message ... OK. Everybody refers to Ron de Bruin for how this is done. I do it...a calendar appears and that's it. I can't make a selection, I can't get rid of the calendar even if I click on another cell. What am I doing wrong? Thanks. -- Rich D Armstrong Custom Homes Redmond |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Calendar drop down
Ron,
Using Excel 2003, windows XP. When I open the calendar control, the box with the triangle (DESIGN?) shows too. -- Rich D Armstrong Custom Homes Redmond "Ron de Bruin" wrote: Hi Rich Which Excel version ? I think you are in Edit mode -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Rich D" wrote in message ... OK. Everybody refers to Ron de Bruin for how this is done. I do it...a calendar appears and that's it. I can't make a selection, I can't get rid of the calendar even if I click on another cell. What am I doing wrong? Thanks. -- Rich D Armstrong Custom Homes Redmond |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Calendar drop down
Also Ron,
When I click InsertObject, there are 2...one says Calendar Control and another says Calandar Control 11.0. -- Rich D Armstrong Custom Homes Redmond "Ron de Bruin" wrote: Hi Rich Which Excel version ? I think you are in Edit mode -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Rich D" wrote in message ... OK. Everybody refers to Ron de Bruin for how this is done. I do it...a calendar appears and that's it. I can't make a selection, I can't get rid of the calendar even if I click on another cell. What am I doing wrong? Thanks. -- Rich D Armstrong Custom Homes Redmond |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Calendar drop down
Maybe you have another program installed that install this control
After you insert it do you see the "Exit Design mode" button on your screen ? Click on it to exit design mode Now the event code will work on the control -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Rich D" wrote in message ... Also Ron, When I click InsertObject, there are 2...one says Calendar Control and another says Calandar Control 11.0. -- Rich D Armstrong Custom Homes Redmond "Ron de Bruin" wrote: Hi Rich Which Excel version ? I think you are in Edit mode -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Rich D" wrote in message ... OK. Everybody refers to Ron de Bruin for how this is done. I do it...a calendar appears and that's it. I can't make a selection, I can't get rid of the calendar even if I click on another cell. What am I doing wrong? Thanks. -- Rich D Armstrong Custom Homes Redmond |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Calendar drop down
I click InsertObjectCalendar Control. A calendar appears along with the
design mode box. Whether I X it or not, the calendar stays, and no selection as to actual date is made. -- Rich D Armstrong Custom Homes Redmond "Ron de Bruin" wrote: Maybe you have another program installed that install this control After you insert it do you see the "Exit Design mode" button on your screen ? Click on it to exit design mode Now the event code will work on the control -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Rich D" wrote in message ... Also Ron, When I click InsertObject, there are 2...one says Calendar Control and another says Calandar Control 11.0. -- Rich D Armstrong Custom Homes Redmond "Ron de Bruin" wrote: Hi Rich Which Excel version ? I think you are in Edit mode -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Rich D" wrote in message ... OK. Everybody refers to Ron de Bruin for how this is done. I do it...a calendar appears and that's it. I can't make a selection, I can't get rid of the calendar even if I click on another cell. What am I doing wrong? Thanks. -- Rich D Armstrong Custom Homes Redmond |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Calendar drop down
Have you copy the code from my site in the correct place
http://www.rondebruin.nl/calendar.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Rich D" wrote in message ... I click InsertObjectCalendar Control. A calendar appears along with the design mode box. Whether I X it or not, the calendar stays, and no selection as to actual date is made. -- Rich D Armstrong Custom Homes Redmond "Ron de Bruin" wrote: Maybe you have another program installed that install this control After you insert it do you see the "Exit Design mode" button on your screen ? Click on it to exit design mode Now the event code will work on the control -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Rich D" wrote in message ... Also Ron, When I click InsertObject, there are 2...one says Calendar Control and another says Calandar Control 11.0. -- Rich D Armstrong Custom Homes Redmond "Ron de Bruin" wrote: Hi Rich Which Excel version ? I think you are in Edit mode -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Rich D" wrote in message ... OK. Everybody refers to Ron de Bruin for how this is done. I do it...a calendar appears and that's it. I can't make a selection, I can't get rid of the calendar even if I click on another cell. What am I doing wrong? Thanks. -- Rich D Armstrong Custom Homes Redmond |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Calendar drop down
Ron,
I've been trying everything to get this to work. Now, when I InsertObjcetCalendar control, it says, "Cannot insert object". -- Rich D Armstrong Custom Homes Redmond "Ron de Bruin" wrote: Hi Rich Which Excel version ? I think you are in Edit mode -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Rich D" wrote in message ... OK. Everybody refers to Ron de Bruin for how this is done. I do it...a calendar appears and that's it. I can't make a selection, I can't get rid of the calendar even if I click on another cell. What am I doing wrong? Thanks. -- Rich D Armstrong Custom Homes Redmond |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| drop-down calendar | Excel Worksheet Functions | |||
| Can I set up a drop-down box with a calendar? | Excel Discussion (Misc queries) | |||
| Calendar on drop down | Excel Discussion (Misc queries) | |||
| drop down calendar | Excel Discussion (Misc queries) | |||
| Drop Down Calendar | Excel Discussion (Misc queries) | |||
Hybrid Mode
