Re: excel: activitaing a macro upon selection of a cell

From: Frank Kabel (frank.kabel_at_freenet.de)
Date: 05/31/04 

Date: Mon, 31 May 2004 13:52:08 +0200

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 *** 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/