navigation

[leo]

My workbook representing a calendar with various
information per date, (each date has 8 cells w/ info
below the date) is used by more then one user.

To allow easy navigation to each (extremely
inexperienced) user,I would like to see the sheet
immediately go to the date that the user provides in a
cell. (I help them do that by using pull-down menu's for
date month year.)

How do I get EXCEL to "JUMP TO" or "GOTO" that date in
the calender?

Thanks

Leo

 

[Frank Kabel]

Hi leo
one idea would be to use the worksheet change event. As you did not
provide more information how your workbook is designed (e.g. one sheet
per month? where does the user enter the date, etc.) just some ideas in
'peudo-code':
- Use the worksheet_change event for the sheet in which the user enters
the date
- parse the date and create a reference to your data
- Activate the respective worksheet and select the cell, column, row

For more information for event procedures have a look at
http://www.mvps.org/dmcritchie/excel/event.htm

HTH
Frank