drop down menu with calendar entry

[Pip]

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

[Nick Hodge]

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
[email protected]HIS


"Pip" <[email protected]> wrote in message
news:[email protected]...
>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

[Ron de Bruin]

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" <[email protected]> wrote in message news:%[email protected]...
> 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
> [email protected]HIS
>
>
> "Pip" <[email protected]> wrote in message news:[email protected]...
>>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]

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" <[email protected]> wrote in message news:%[email protected]...
> > 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
> > [email protected]HIS
> >
> >
> > "Pip" <[email protected]> wrote in message news:[email protected]...
> >>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
> >
> >
>
>
>

[Ron de Bruin]

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" <[email protected]> wrote in message news:[email protected]...
> 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" <[email protected]> wrote in message news:%[email protected]...
>> > 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
>> > [email protected]HIS
>> >
>> >
>> > "Pip" <[email protected]> wrote in message news:[email protected]...
>> >>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
>> >
>> >
>>
>>
>>