To look up a date in a Table use the Vlookup or Match & Index formula
(see Excel help for more info).
In VBA this is Application.Worksheetfunction.VLOOKUP(.... &
Application.Worksheetfunction.Match(....
Put this into the Worksheet_Change event so this happens on user
changing any cell.

With regards to the Calendar part, consider using a 3rd party
Application like WinCalendar for Excel.
See http://www.wincalendar.com/excel-calendar.html for more info.

Regards
TG

On Jul 31, 11:59 pm, " wrote:
Hi,

I would like to know if there are ways that if i key in the date say
15/08/2007, it will get the cell that contains the events such as
attend party. This will then input this event to thecalendaron date
15/08/2007.

Please advise.

rgds,
Y.H