98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Generating 'pop-up' calendar upon clicking a cell | Excel forum
Generating 'pop-up' calendar upon clicking a cell | Excel forum
Resolved · Urgent Priority · Version 2003
Fri 1 May 2009, 09:57Delegate Francis said...
Francis has attended:
Excel Advanced course
Generating 'pop-up' calendar upon clicking a cell
Hi,
I would like to generate a 'pop-up' table calendar upon clicking to make date entry easy for my users.
How do I do this?
Thanks!
Fri 1 May 2009, 10:56Trainer Anthony said...
RE: Generating 'pop-up' calendar upon clicking a cell
Hi Francis. The simple answer to this question is: you need an add-in! Otherwise you're looking at a VBA coding job - there is no standard function in Excel to achieve this. Here are two links which go into further detail:
http://www.fontstuff.com/vba/vbatut07.htm
http://www.office-kit.com/excel_calendar/
Hope this helps,
Anthony
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Closing Multiple Open Worksheets At OnceWhen multiple Excel worksheets are opening, rather than performing a File > Close menu option multiple times, hold down the the SHIFT key and select the File > Close All menu option. |
