Automatic Comments

**btominey** · 07-05-2011, 05:09 AM

Hello All

I have a very simple spreadsheet, with a series of question boxes, which require a Yes or No Answer.

If the answer is 'No', I would like the comment box to automatically open so that someone could write in a reason for the no answer. The comment box should then close when you move to the next box - If the answer is 'Yes' nothing should happen.

Is this possible?

**btominey** · 07-06-2011, 03:30 AM

Originally Posted by btominey

Hello All

I have a very simple spreadsheet, with a series of question boxes, which require a Yes or No Answer.

If the answer is 'No', I would like the comment box to automatically open so that someone could write in a reason for the no answer. The comment box should then close when you move to the next box - If the answer is 'Yes' nothing should happen.

Is this possible?

Someone Please Help Me! I think I am going mad!!!!!