here is my problem ... i have created a crossword in excel. there is a
part of the sheet which dsiplays one clue at a time. to change the clue
displayed, i have a pull-down list from which i select the required
clue number and then the corresponding clue gets displayed.

now instead of i having to use the pull-down list, this is what i'd
like to have ... to display a clue i click on a cell inside the
crossword grid, the cell where the answer for the particular starts. of
course in a case where the particular cell is the first cell for two
answers (one "across", and the other "down"), id like to have one of
the two clues (across or down) to be displayed based on the value (a or
d) entered in a pre-specified cell.

can someone help me do this, please?


---
Message posted from http://www.ExcelForum.com/

Hi
you need VBA for this. Using the selection_change event for this. See:
http://www.cpearson.com/excel/events.htm

--
Regards
Frank Kabel
Frankfurt, Germany


here is my problem ... i have created a crossword in excel. there is
a
part of the sheet which dsiplays one clue at a time. to change the
clue displayed, i have a pull-down list from which i select the
required clue number and then the corresponding clue gets displayed.

now instead of i having to use the pull-down list, this is what i'd
like to have ... to display a clue i click on a cell inside the
crossword grid, the cell where the answer for the particular starts.
of course in a case where the particular cell is the first cell for
two answers (one "across", and the other "down"), id like to have one
of the two clues (across or down) to be displayed based on the value
(a or d) entered in a pre-specified cell.

can someone help me do this, please?


---
Message posted from http://www.ExcelForum.com/