Calendar Autoupdate
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
|