On my worksheet, i have around 15 different dropdown lists that all work off variable inputs.
I have a Working VBA Code that allows me to clear contents of one cell if the input is changed, but as a VBA novice i cannot adapt it to work with different inputs and outputs. I have tried searchign the forums, but can only find references to where people want to clear one cell.
Option Explicit
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Cells.Count > 1 Then Exit Sub
If Not Intersect(Target, Range("D3")) Is Nothing Then
Range("E3:H3").ClearContents
End If
End Sub
This is what im working with at the moment but want to add in more variables such as if "D4" is changed then clear "E4:H4" same with D5- E5:H5 ect
Any help would be apriciated.
Also there are other parts in the spreadsheet that i could use this on, but again on the same page so eg, if B4 is changed then clear B5, so all of the changes are not in a linear fashion.
Thanks in advance for anything you can do to help.
Bookmarks