Hi,

Yes it will be used on a worksheet. I have made the calendar in the user
forms bit and i have also got it set up so it automatically feeds into the
cells when clicked on, but I don't have any code to make it start up when I
click on the specific cells.

"Ron de Bruin" wrote:

Do you use the calendar control on a worksheet ?
See
http://www.rondebruin.nl/calendar.htm



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Pasty" wrote in message ...
I have recently started teaching myself VBA and am still getting to grips
with it. I have created a calendar and its all working fine but how do I get
it to only pop up if they select a certain column or cell.

Regards