Userform Calendar Double click control

Hi all,
I made a userform for calendar so rather than using the datepicker which kept breaking i made a seperate userform to use as a date picker with the calendar control in.

i've done a control button so when a user single clicks on the date in the calendar it selects the date and enteres it into my other userform but id like to find if there is a way that when a user double clicks on the date it also selects it and closes the userform.

any ideas?
is this possible?

many thanks

Hi

I had sometyhing very similar, opening another userform just for a calendar. Im not sure about a double click, but the following code is an exact copy of what i used. The userform was opened, user clicks on date, userform closes and date goes into textbox5. See if you can make sense of it.

Please Login or Register  to view this content.