How do I format a cell, so the user must use a user calendar?

[nathan]

I created a user calendar by means of a macro. I want to set a cell in the
workbook so when someone clicks on the cell the calendar automatically comes
up so they can select a date.

[Gord Dibben]

nathan

See Ron de Bruin's site for code.

Adjust the range to suit

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


Gord Dibben MS Excel MVP

On Mon, 16 Jan 2006 09:25:03 -0800, nathan <nathan@discussions.microsoft.com>
wrote:

>I created a user calendar by means of a macro. I want to set a cell in the
>workbook so when someone clicks on the cell the calendar automatically comes
>up so they can select a date.