Run a macro when date picker chages

Unfortunately, a Worksheet_Change event is triggered only if a change is made manually to a cell.

Unfortunately, a Worksheet_Change event is triggered only if a change is made manually to a cell. There is an alternate to using a DatePicker ActiveX control. Have a look at the attached file. If you click A1, a calendar will pop up and a message will be displayed. The worksheet code module has two event macros, one to display the calendar and one to generate the message once you pick a date. Instead of displaying the message you can call your macro.

Looking very promising. I will test it out to see if it achieves what i need.
Thank you.

Works like a charm with little alteration to my own settings.

You are very welcome.

I found the code which creates this calendar online some time ago (I wish I could remember where so I could give credit). Changing the functionality would involve changing the code that drives the calendar, which is quite involved. It would be difficult for me to modify it.

My pleasure.