Delete cell based on dropdown

[iluvfnky]

Hi,

I want to delete a cell based on a list option. If my list has "multibuy" selected then that's ok, but if another option is selected from the list I want the contents of K4 & K5 to clear or delete.

Is this possible?

 

[jeffreybrown]

You didn't say what cell your drop down list was in so I make it K3. Just change it if this is not right.

Right click on the sheet tab >> view code >> paste code on right side of screen.

Private Sub Worksheet_Change(ByVal Target As Range)
    Dim Rng As Range
    Set Rng = Target.Parent.Range("K3")
    If Target.Count > 1 Then Exit Sub
    If Intersect(Target, Rng) Is Nothing Then Exit Sub
    If Target.Value <> "multibuy" Then
        Range("K4").Resize(2).Clear
    End If
End Sub

 

[iluvfnky]

Thanks,

But I get an error relevant to the line below. Any ideas?

Range("K4").Resize(2).Clear

 

[iluvfnky]

Problem solved, just removed the merged cell and it fixed it. Thank you so much for your help.

 

[jeffreybrown]

Glad it worked for you...you're welcome