Run Macro when click on merged cells

I have a sheet called "TSA Request" and in cell F8:I8, I want the agents to put the date needed. I created a userform1 which is calendar that when I click in that range, it will pop open the calendar and put the date in the Cell F8:I8 which I select from the calendar. I believe I have everything together - just need the VBA to do as I need. I have attached the sheet for any help. Thank you in advanced!

you have 2 dates in calender, wich 1 has to go to range F8 ?

Kind regards
Leo

In Worksheet

Please Login or Register  to view this content.

For CommanButton OK on Userform

Please Login or Register  to view this content.

Kind regards
Leo

Leo the only issue now is that the months and days are not populating in the calendar correctly - can you assist?

I did not make any changes to that part, and here it is populating correct
so wondering, remove the code provided by me and see if there is any difference



Kind regards
Leo

This is the code I am getting an error at:

Please Login or Register  to view this content.

The calendar doesn't show any months or years & the days are more than they are in a month (example: 42).

and wich part in this sub is different then before ?

Kind regards
Leo