Clear cell value if drop down is selected again

[ipbr21054]

Hi,
Ive attached a screenshot to assist you
I have 2 drop down boxes.
G13 & M11
Currently A BAKALO 001 is shown in cell G13 & BIKE is shown in cell M11

If the user decides to select again using drop down in cell G13 so TOM JONES now replaces A BAKALI 001 currently BIKE is still shown in cell M11
It needs to be cleared so the user can make the correct selection
Thanks

 

[Jeffrey Mahoney]

Paste this into the SHEET module. It is best to give those ranges names and then reference the names in the macro. This allows you to move those anywhere and the macro won't break

Private Sub Worksheet_Change(ByVal Target As Range)
  
  If Not Intersect(Target, Range("G13")) Is Nothing Then
    Application.EnableEvents = False
    
    If Range("G13").Value <> "" Then
      Range("M11").Value = ""
    End If
    
    Application.EnableEvents = True
  End If
  
  
End Sub

 

[ipbr21054]

Thanks very much, now working