Why not rather insert a userform with a calender control in your
Personal.xls, and assign it to the right click menu. This way, you select
the cell where you want to add the date, right click, select the date you
want, and click on it to insert the date in the active cell. Check out
http://www.rondebruin.nl/calendar.htm. I had one problem with this code, and
that is that the before close portion does not work. I moved the line to
delete the control to the first line of the on open event, and that solved
the problem

"Hot rod" wrote:

Can I create a list that contains a calender. My project is to allow
co-workers to click on list (drop down) and a calender will appear for them
to schedule/request dates for their appointments.