Hi Mark, Bob, Steve,

Thank you for your your great contributions, it's thanks to experts sparing their time and knowledge that noobs like me learn anything.

Mark, your solution is interesting using the QueryClose event to offset the activecell.

However based on your comment regarding any issues faced with this method in Post#13, Bob's method is probably more suited to this purpose. Thank you for your input though, I'm sure I can use this in another application.

Bob, thank you for your great manipluation to the existing method to add the double click methodology.

Just one question though, how can I force the user to not be allowed to enter any data (or should I say date-a) manually. If they start typing, it should prompt them to double click, or even better pop up the Userform. So in this case the Userform is not just popping-up on selecting or double clicking, but also of they try to manually re-type a value in the cell.

BTW, what you have done is fantastic, I was just wondering if this is possible as it is a form of validation and ensures that the user is forced to use the Calendar for the purpose that it was built for in the first place.

thanks and regards,