Close Non-activex Datepicker Calendar Control on Userform

Hi,

This has been cross posted from http://www.ozgrid.com/forum/showthread.php?t=156614 due to a lack of response.

I have used a variation of the Non-activex Datepicker Calendar Control from the open source forumhttp://www.ozgrid.com/forum/showthre...=142603&page=1.

The user clicks the command button to get the calendar to pop up - perfect.

But if it’s an error or they change their mind I need the pop up to disappear if the user clicks anywhere else in the user form.

I had done this through a transparent label the size of the user form.
I set its visible property to false on initialisation.
Activating the calendar pop up brings the label between the rest of the user form and the date picker & sets it to visible.

I then use the click event on the label to simulate a cancel click on the pop-up itself. This then hides both the pop up and the label, allowing the user to continue.

This works beautifully until I try to deploy the solution on a Userform with frames. The label will not show in front of the frames.

Is this "by design" from MS?

I've tried setting the focus to the pop up but as its just a frame and a collection of labels there's no real entry or exit to trigger the events.

I could change the label for a frame as my experiments (on empty userforms /projects) seem to support that this will work but can anyone please suggest a more elegant solution?
up to disappear if the user clicks anywhere else in the user form.

I had done this through a transparent label the size of the user form.
I set its visible property to false on initialisation.
Activating the calander pop up brings the label between the rest of the user form and the date picker & sets it to visible.

I then use the click event on the label to simulate a cancel click on the pop-up itself. This then hides both the pop up and the label, allowing the user to continue.

This works beutifully until I try to deploy the solution on a Userform with frames. The label will not show in front of the frames.

Is this "by design" from MS?

I've tried setting the focus to the pop up but as its just a frame and a collection of labels there's no real entry or exit to trigger the events.

I've tried changing the label for a frame as my experiments (on empty userforms /projects) seem to support that this will work but of course (unless I've missed it) you can't have a transparrent frame.

Can anyone please suggest a soluiotn?

Thanks

James