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, "new...@gmail.com" <lee...@gmail.com> 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 <tech...@paymentapplication.com> 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, "new...@gmail.com" <lee...@gmail.com> 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, "new...@gmail.com" <lee...@gmail.com> wrote:
> On Aug 1, 1:17 pm, TechGuy <tech...@paymentapplication.com> 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, "new...@gmail.com" <lee...@gmail.com> 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