Try using the Worksheet change event. Check to see if your cell is the
target, if so you then use VBA to pop up your message box and perform your
actions

Regards
--
Tony Green


"IReeve" wrote:

I am looking for a way for a user to type a value into a cell, but then when
the user "exits" the cell, I want it to ask a Yes/No question and then do
things based on the answer