excel: activitaing a macro upon selection of a cell
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/ |
excel: activitaing a macro upon selection of a cell
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/ |
All times are GMT +1. The time now is 10:48 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com