Enforcing an input based on a value ??

[Brad]

Hi Guys,

I need to let a user put a value in a cell. If that value = anything other than say X then they need to be forced to put a value in the cell next to it.

I want to enforce this so that they can not continue until they have but the comment in.

Any ideas ?

Thanks for you help

 

[HaHoBe]

Hi, Brad,

as I do have my problems solving these kind of problems utilizing Data/Validation I usually make use of the workheet_Change-event behind the sheet to check and decide which further action to take. It´s an absolutely must for the use of macros in the workbooks thereafter.

Ciao,
Holger