Trigger macro if drop down selection is changed.

Hi, I have a form where the user selects a chemical from the drop down (B5), then enters a date (B7). Based on the chemical and date entered, the form populates an expiration date on the form. My issue is that if you change the drop down after entering the date, the expiration date doesn't get updated since the formula is triggered off the date field only. How can I clear the entered date (B7) if the drop down selection changes (B5). I tried the following formula:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    If Target.Address = "$B$5" Then
        Range("B7").ClearContents
    End If

End Sub

However, once you enter the date, it returns you to the drop down cell, so Excel see this as a selection change and runs the code to clear the form. I need it to only change if you make a different selection from the drop down, not when the cell is selected.

Thanks,

Scott

This thread is locked. You can vote as helpful, but you cannot reply or subscribe to this thread.