Pass Date value from custom calendar control to Userform Combo Box:

Good Evening,


File attached.

In the attachment I have two user forms.

UserForm1 has a combobox --> click on the dropdown arrow

Userform - uf_Calendar will show.

When I double click on the Date in the custom Calendar control, I want the date value passed on to the combobox in UserForm1.

pls help

thanks
R

Try textbox instead of combobox. See below code.

Please Login or Register  to view this content.

Thanks Thameem,

the code worked with the combo box as well. However I use the calendar control on many combo boxes (for Eg: DOB, Employment Start Date, employment end date, etc...) hence I would like to capture the 'date value' in a variable & then pass it on to relevant combo box..