I have a cell which has a "yes/no" option using data validation. I want a messagebox to appear when the user selects "yes". I have tried "worksheet_change" but obviously the message keeps appearing when others cells are changed. I only want it to happen when the "yes/no" cell is changed. can anyone help?
Thanks in adavnce
Derek