Entering dates in a cell as calender

Hi Tahir,

Thank you for the forum question.

You can download Date Picker from the Add-in store from the Insert tab in Excel, but this will not do exactly what you want. It will add a permanent calendar on the sheet.

To do what you want you will need to VBA code a ActiveX control. I do not know if you have VBA knowledge to do this.


Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector