Clear selection when another choice made in dropdown list.

[Crispy85]

Hi all,

I'm not really able to upload my form due company privacy and clearing the form would take a long time.
So i will try and explain my question:

In cell B11 there is a dropdown-list which let a user choose an item.
In cell B17 there is a dropdown-list which let a user choose a dealer for this item.

Item has it's own dealer, via a formula i determine the dealers per item with data validation.
However when an item and a dealer has been chosen, and someone changes the item, the dropdownlist in B17 will be updated but the previously chosen dealer will be stayed displayed.

Is there an easy way to script when the value of B11 has been changed, the value of B17 should be overwritten with: Select dealer


Thanks for all your help!!

Regards,
Crispy

[6StringJazzer]

Put this code into the Worksheet module for the worksheet containing this data. This worked in my test but caveat emptor since I don't have your file.

Private Sub Worksheet_Change(ByVal Target As Range)

   If Not Intersect(Target, Range("B11")) Is Nothing Then
      Range("B17").Value = "Select dealer"
   End If

End Sub

[gmr4evr1]

Maybe...

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$B$11" Then
[B17] = "Select Dealer"
End If
End Sub

[Crispy85]

I just put it in the initial Macro.
Thanks all!

[Crispy85]

Hi both,

Thanks for your reactions.
These both aren't working, could this because i allready have a Private Sub Worksheet_Change set in my sheet?
Naming it to Worksheet_Change 2 doesn't work i guess lol.

[6StringJazzer]

[...]could this because i allready have a Private Sub Worksheet_Change set in my sheet?

Yes. Post your code and I'll show you how to modify it.

[gmr4evr1]

You're welcome.