Calendar popup when cell is clicked

Hello Ranyere,

Hope you enjoyed your Microsoft Excel VBA course with Best STL.

Thank you for your question regarding using a calendar popup when a cell is clicked.

In the past I have inserted the Calendar Control 11.0 or 12.0 (click and drag the Calendar onto the spreadsheet) and then created a tiny piece of code by double clicking the calendar and inserting the following:

ActiveCell = Calendar1

The number appearing after the word Calendar should match the first line of the code module. In other words if you have inserted several calendars, one on each sheet, then the Calendars will be numbered consecutively.

I have always placed the Calendar in the top right corner and applied Freeze Panes to keep the Calendar permanently in view. Make sure that the date column is formatted with whatever date format you require otherwise if you click on a cell and then click a date on the calendar it will produce a number. This of course is not a problem since all you have to then do is format the cell as a date.

I find the date picker too cumbersome, however, if the option I have suggested is not right for you, let me know and I'll try to find a better solution.

I have attached a file with a calendar control for you to have a look at. Click a blank cell in the date column and click a date in the calendar.



I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Rodney
Microsoft Office Specialist Trainer