Need assistance with multiple ClearContents instances within Worksheet_Change

[brought]

I have two drop down lists. When the first drop down value is changed, the second automatically clears its value. I am performing this using the following:

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = Range("O2").Address Then
Range("P2").ClearContents
End If
End Sub

I now have a second set of unrelated drop down lists that I would like to see work the same way where, when the value in "O5" is changed the contents in "P5" are cleared. Any assistance would be greatly appreciated as I am having issues getting both of these actions to work on the same worksheet.

 

[My Aswer Is This]

Try this:

Private Sub Worksheet_Change(ByVal Target As Range)
 If Target.Address = Range("O2").Address Then
 Range("P2").ClearContents
 End If
 
 
 If Target.Address = Range("O5").Address Then
 Range("P5").ClearContents
 End If
    
 End Sub

 

[brought]

That did the trick. Thanks so much!

 

[My Aswer Is This]

Glad I was able to help you. Come back here to Mr. Excel next time you need additional assistance.

That did the trick. Thanks so much!