Sounds like a lot of work, but you could use the change event to react to an
entry:

for a start, See Chip Pearson's page on events

http://www.cpearson.com/excel/events.htm

--
Rgards,
Tom Ogilvy
"TBD" wrote in message
...
Hi all! I have set up a "fun" office quiz sheet, with a number of
questions
with specific one and two-word answers. I have protected the sheet so it
is
only possible to enter text into the specific "Answer" Cells. A cell next
to
these answers tells the user whether the answer is correct or incorrect.

However, I would like to be able to limit the number of incorrect answers
a
user can enter into one cell (for example - 3 attempts), and if they enter
an
incorrect answer 3 times the cell becomes locked with their last attempt.
Is
it possible to do this?

Any help anyone could give would be much appreciated!!!