My thought is, just Right click on the tab name and select View Code...

Change the left drop-down to Worksheet

then enter

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Range("B10").Value < "" Then
Range("B9").Value = ""
End If
End Sub


"MichaelZ" wrote:

In cell B9 I have a dropdown list of health-related questions that a user can
select from.
In cell B10 I have a dropdown list of more specific health-related questions
that a user can select from.
What I'd like to do is, if the user chooses one of the questions from the
dropdown list in cell B10, I'd like the contents of cell B9 to be blank. How
can I do this? Thanks in advance.