| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Jeopardy
For a team building excerise I need to build a jeopardy board in excel. How
can I format a cell to change colors after it has been clicked on? The plan is to have a cell one color with a $ value on it. The $ value will be a hyperlink to a word document with the answer. When the question is figured out the word document will be closed. The excel cell needs to then contain the correct question and be a different color so the contestants know that option is no longer available. Anyone have any ideas how to accomplish this? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Jeopardy
The easiest would be to do it as a Before Double-click event, you can also
call your Word stuff from there if needed. -- -John Please rate when your question is answered to help us and others know what is helpful. "PAR" wrote: For a team building excerise I need to build a jeopardy board in excel. How can I format a cell to change colors after it has been clicked on? The plan is to have a cell one color with a $ value on it. The $ value will be a hyperlink to a word document with the answer. When the question is figured out the word document will be closed. The excel cell needs to then contain the correct question and be a different color so the contestants know that option is no longer available. Anyone have any ideas how to accomplish this? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Jeopardy
How do I do that? I don't know how to enter VB in excel.
"John Bundy" wrote: The easiest would be to do it as a Before Double-click event, you can also call your Word stuff from there if needed. -- -John Please rate when your question is answered to help us and others know what is helpful. "PAR" wrote: For a team building excerise I need to build a jeopardy board in excel. How can I format a cell to change colors after it has been clicked on? The plan is to have a cell one color with a $ value on it. The $ value will be a hyperlink to a word document with the answer. When the question is figured out the word document will be closed. The excel cell needs to then contain the correct question and be a different color so the contestants know that option is no longer available. Anyone have any ideas how to accomplish this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
