Requiring Data Entry in Cell B (et al) when Data has been entered in Cell A.

Hi. I need some advice on this form I am creating.

For instance, In Cell A, there is drop down menu which has the selection "yes" & "no".

Then there's Cell B, C, D, E, F which are in turn refers to the source of the Cell A's data (e.g. Home, School, Office, Cafe, Others).

When the answer in Cell A is "Yes", respondents are then required to select (thru dropdown the "√" symbol) at least 1 or more from B, C, D, E, F. Respondents should make at least 1 selection from B-F if they answer "Yes" to Cell A.

* Cell A = Has Internet Connection? Yes/No
* Cell B-F = Where do you connect to the Internet? Choose 1 or more by "√".


What VB script can I use for this? Would really appreciate this. Thank you very much.

Sorry for cross posting but I am really pressured to find a solution to this. I don't do much VB so I need all the help I can get.

Attached is the sample.

Thanks for the help.

Please help!

Thank you very much for the reply.

The code does work with 1 work sheet with 1 rule. But it does not seem to work when there are several worksheets and columns needing the same rules. Maybe I am doing it wrong but I can't seem to get it to work with the other sheets.

The actual workbook I am working on has 12 sheets with a number columns needing the same rules.

I just decided to do a validation with a warning message when cell A is selected and conditional formatting which highlighted the required cells when cell A has been answered as users were also disabling the macros which invalidated the code.