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

closing userform automatically
 

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" wrote in message ...
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