Set a cell to have a pop-up calendar for date selection in Excel?- when a worksheet

What I want to do is when a worksheet user selects a given cell, one of those
handy calendars pops up from which the user can select a year, month and date.

I was hoping there was an add-in of some sort or a VB script.

See
http://www.rondebruin.nl/calendar.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Michigander-77" <[email protected]> wrote in message
news:[email protected]...
> What I want to do is when a worksheet user selects a given cell, one of those
> handy calendars pops up from which the user can select a year, month and date.
>
> I was hoping there was an add-in of some sort or a VB script.

See Ron de Bruin's site for calendar and code.

http://www.rondebruin.nl/calendar.htm


Gord Dibben Excel MVP

On Thu, 14 Jul 2005 13:37:02 -0700, "Michigander-77"
<[email protected]> wrote:

>What I want to do is when a worksheet user selects a given cell, one of those
>handy calendars pops up from which the user can select a year, month and date.
>
>I was hoping there was an add-in of some sort or a VB script.