excel: activitaing a macro upon selection of a cell

[arunjoshi]

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?

 

[Frank Kabel]

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