Calendar Autoupdate

[newbie]

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

 

[TechGuy]

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

 

[newbie]

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






- Show quoted text -

Hi,

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

rgds,
Y.h

 

[TechGuy]

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