closing userform automatically

Hi
I have set up a userform calendar. To enter a date in a cell, all I have to
do is click on a day of the month in the calendar. It automatically enters
the date in the previously selected cell. How can I get the userform to
close as soon as I click on a day in the userform calendar. It would be nice
not to have to click the closeit X to close the userform. I have many dates
to enter in a column and it would save a lot of time if it closed as soon as
I clicked on a day. Thanks

Hi jim

After the code that insert the date in the cell
Add this

Unload Me

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


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


"Jim Brass" <jbrass@cfu.net> wrote in message news:dfhgee$of3$1@news.cfu.net...
> Hi
> I have set up a userform calendar. To enter a date in a cell, all I have to do is click on a day of the month in the calendar. It
> automatically enters the date in the previously selected cell. How can I get the userform to close as soon as I click on a day in
> the userform calendar. It would be nice not to have to click the closeit X to close the userform. I have many dates to enter in a
> column and it would save a lot of time if it closed as soon as I clicked on a day. Thanks
>