Require to add a comment

[Tileplayer]

I hope somebody can help on this.


I'm preparing a file for the evaluation of several items. For every item evaluated (in one cell), the user must enter the reason of the evaluation (in another cell).

How can I do this? I don't want to have any item evaluated without the reason for the evaluation.


Thanks in advance for your help


Rafael

 

[Luke M]

You could use conditional formatting to flag the cell. Let's say the item is in col A, and the reason needs to be in col B. With cell B2 selected, CF formula would be:

=AND($A2<>"",ISBLANK($B2))

Pick a nice format, such as a red fill.

This should flag any cells that either have an item w/ no reason given.

 

[Tileplayer]

Thanks for your answer, but what I need is something that force the user to enter a comment and not allow him to go forward until the information is given.


Thanks.

 

[shrivallabha]

You will have to go VBA route e.g. using Userform or Sheet based event which will control the user input.


However, it will require efforts. Especially if you don't have background in VBA.