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 the calendar on date
15/08/2007.

Please advise.

rgds,
Y.H

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

On Aug 1, 1:17 pm, TechGuy wrote:
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.
Seehttp://www.wincalendar.com/excel-calendar.htmlfor 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- Hide quoted text -

- Show quoted text -

Hi,

How to code in vba using Application.Worksheetfunction.VLOOKUP and
Application.Worksheetfunction.Match?

rgds,
Y.h

On Aug 1, 2:46 am, " wrote:
On Aug 1, 1:17 pm, TechGuy wrote:





To look up a date in a Table use the Vlookup or Match & Index formula
(seeExcelhelp 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 theCalendarpart, consider using a 3rd party
Application like WinCalendar forExcel.
Seehttp://www.wincalendar.com/excel-calendar.htmlformore 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- Hide quoted text -

- Show quoted text -

Hi,

How to code in vba using Application.Worksheetfunction.VLOOKUP and
Application.Worksheetfunction.Match?

rgds,
Y.h- Hide quoted text -

- Show quoted text -

The VBA functions work very similar to the worksheet function & are
highly optimized. Best to refer to VBA help for more info (beyond the
scope of this forum).
Good luck
TG