If drop down input selected as "No" can you force input to another cell?

**YOIYOU** · 03-26-2020, 01:33 PM

Good afternoon all,

So I have another query....

Is it possible to force input in another cell if a certain condition is selected?

I have a cell where data validation from a list only allows Input of Yes Or No. If the criteria of No is selected is it possible to force the user to input data in to another cell?

The theory behind it is, the column asks if something is working, if the user selects No I am trying to make them record the Log number they received from the maintenance team when they report the broken item.

Is this possible, if so how?

Any help would be greatly appreciated.

Kind regards,

Y.

**6StringJazzer** · 03-26-2020, 03:16 PM

It is possible but forcing user input requires macros. It would help to have your file, but without it I can describe the general approach.

**YOIYOU** · 03-27-2020, 05:12 AM

Morning.

Thanks for the response.

I have attached a sanitised copy of the worksheet I am using with some dummy data, however the format etc is the same. I hope this helps.

In essence if Coulumn D and Column J are selected as No I am trying to force input to column E / K for the respective row.

I hope that makes sense.....

**6StringJazzer** · 03-27-2020, 12:08 PM

Here is a VBA solution that won't let the user do anything if they select No without entering a log number.

You were missing the Yes/No in column Z so I put that in.

If the user selects No, it immediately prompts to fill in the log number, and it won't let you go anywhere else until you do, except to change the No back to Yes.