Calender in a userform combo box

Could somebody please help me with creating a calendar popup when somebody clicks on a combo box.


thanks


Josh

the solution does work.

I have one problem or question though?


Is there a way or how do I do the following.

I have a combo box on a userform (ComboBox1)

when my event is enabled (dblclick)

it does frmCalendar.show


so when they (click) on a date it puts the date into the original combo box(ComboBox1)

frmCalendar.hide


my problem is what if you have 2 combo boxes and they both want to access the calendar


the code in the frmcalendar is telling when clicked put the value in combox box 1, is there anyway to know (by coding) where the set.focus is and return there with the value


thanks for any help


Josh