How do I implement a frmCalendar?

Hello -

I found this link while looking for help on how to implement a frmCalendar: http://www.fontstuff.com/vba/vbatut07.htm.

I'd like to know how to adjust this to make a calendar pop up when clicking on only cell A2. I'd like a user to double-click a date, have that date entered into A2 as "mm/dd/yy", and then have the calendar close.

Any help would be greatly appreciated!

Thank you for the quick response!

Ok, I took the example from that website and put it into an Excel workbook. I've attached the workbook so you can see what I did. However, I'm not sure how to add your code to the workbook to get it to work correctly.

Bumping post

Thank you both!

I ended up using this code:

Please Login or Register  to view this content.

I found this in another post: http://www.excelforum.com/showthread...ht=frmCalendar

One more thing.

I have to merge cells A2 and B2 for the answer field. By using the code I posted just above, I cannot get the calendar to come up when I click on the merged area. If I unmerge and click on A2, it works fine. Any suggestions as to how I should fix this?

I got it to work by changing Target.Cells.Count=1 to Target.Cells.Count=2.

Thank you!