| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
drop down menu with calendar entry
I have figured out creating drop down menus using the validation option but
what I would like to do is have a scrollable calendar in that field. Is there a way to put a calendar in pull down menus or would someone recommend another way to approach this? rgds Pip |
|
#2
|
|||
|
|||
|
Pip
I have a calendar demo on my site http://www.nickhodge.co.uk/vba/codeexamples.htm -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England HIS "Pip" wrote in message ... I have figured out creating drop down menus using the validation option but what I would like to do is have a scrollable calendar in that field. Is there a way to put a calendar in pull down menus or would someone recommend another way to approach this? rgds Pip |
|
#3
|
|||
|
|||
|
Hi
Another way without a userform is this one You can also download the control (see link on my page) http://www.rondebruin.nl/calendar.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Nick Hodge" wrote in message ... Pip I have a calendar demo on my site http://www.nickhodge.co.uk/vba/codeexamples.htm -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England HIS "Pip" wrote in message ... I have figured out creating drop down menus using the validation option but what I would like to do is have a scrollable calendar in that field. Is there a way to put a calendar in pull down menus or would someone recommend another way to approach this? rgds Pip |
|
#4
|
|||
|
|||
|
Thanks to both of you. Ron, I have been working through your VBE setup and
when I try to add the calendar control to the user form, it comes up with library not registered. Any clues on that one? I have already installed the ..ocx that I didnt have previously. rgds Pip "Ron de Bruin" wrote: Hi Another way without a userform is this one You can also download the control (see link on my page) http://www.rondebruin.nl/calendar.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Nick Hodge" wrote in message ... Pip I have a calendar demo on my site http://www.nickhodge.co.uk/vba/codeexamples.htm -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England HIS "Pip" wrote in message ... I have figured out creating drop down menus using the validation option but what I would like to do is have a scrollable calendar in that field. Is there a way to put a calendar in pull down menus or would someone recommend another way to approach this? rgds Pip |
|
#5
|
|||
|
|||
|
Hi Pip
On the website there is a explanation how to register it http://www.fontstuff.com/vba/vbatut07.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Pip" wrote in message ... Thanks to both of you. Ron, I have been working through your VBE setup and when I try to add the calendar control to the user form, it comes up with library not registered. Any clues on that one? I have already installed the .ocx that I didnt have previously. rgds Pip "Ron de Bruin" wrote: Hi Another way without a userform is this one You can also download the control (see link on my page) http://www.rondebruin.nl/calendar.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Nick Hodge" wrote in message ... Pip I have a calendar demo on my site http://www.nickhodge.co.uk/vba/codeexamples.htm -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England HIS "Pip" wrote in message ... I have figured out creating drop down menus using the validation option but what I would like to do is have a scrollable calendar in that field. Is there a way to put a calendar in pull down menus or would someone recommend another way to approach this? rgds Pip |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is there any way to create a drop down calendar into a cell in ex. | Excel Discussion (Misc queries) | |||
| help with drop down menu data | Excel Discussion (Misc queries) | |||
| Applying a formula to a drop menu choice | Excel Discussion (Misc queries) | |||
| How do I set up a drop down menu for a validation list? | Excel Worksheet Functions | |||
| create calendar drop down list in Excel sell | New Users to Excel | |||
Linear Mode
