Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

generating popup calendar upon

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Generating 'pop-up' calendar upon clicking a cell

Generating 'pop-up' calendar upon clicking a cell

ResolvedVersion 2003

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!

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 courses

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
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

Excel tip:

Separate the year from a date

To separate the year from a date use the =year() function, eg a date is in cell A1 and in A2 you wish to display the year enter the function =year(A1)

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.08 secs.