Validation and formula combined?

[proepert]

I have a Yes/No list that I use in two cells for data validation:

Cell A1 has the Yes/No list for data validation.

Cell A10 has the Yes/No list for data validation.

I want A10 to become No if the user selects "No" in the A1 pull-down list.

Is this possible?

[modytrane]

Does A10 become Yes when A1 is Yes?

Why does A10 have validation list?
Why can't A10 just be =A1.?

May be there is more to it, so please explain.

modytrane

[proepert]

Does A10 become Yes when A1 is Yes?

No, A10 can be No when A1 is Yes

Why does A10 have validation list?

Only Yes and No are valid entries

Why can't A10 just be =A1.?

See above.

Thank you.

[proepert]

I have this working, not sure this is the best method, but it is working. The actual cell numbers are different from the original question.

Private Sub Worksheet_Change(ByVal Target As Range)
With Target
If .Address = "$O$34" Then
If LCase(.Value) = "yes" Then
Range("$O$35:$O$42").Value = "Yes"
Else
Range("$O$35:$O$42").Value = "No"
End If
End If
End With
End Sub