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 |
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 |
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 |
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 |
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 |
All times are GMT +1. The time now is 05:25 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com