Solved Change color after 1 click?

July 1, 2012 at 08:15:40
Specs: Windows XP
I'm making a Jeopardy Game. The board is 5 rows from $100 to $500 and 5 columns. I want to change the font color to grey or another color after I've clicked it to show the students they can't choose that option anymore after someone has chosen it. The excel spreadsheet is in a Powerpoint presentation if that matters.

See More: Change color after 1 click?

Report •

July 2, 2012 at 06:04:22
✔ Best Answer
This code, when stored in the sheet module, will turn a cell gray as soon as it is clicked.

I don't know if it will work in a sheet embedded in a PowerPoint presentation.

If it doesn't, I don't have any other suggestions because I don't know PowerPoint well enough to make this happen.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
  Target.Interior.ColorIndex = 48
End Sub

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •
Related Solutions

Ask Question