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

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.11 secs.