NeedhelpinIndiana
New Member
- Joined
- Nov 6, 2007
- Messages
- 3
I have created a form that utilizes drop down boxes to narrow down the user selection based upon the previous column's input. Thus, C3 selection of size is narrowed down based upon A3 and B3's selections, where B3 section of color, is narrowed down by A3 selection of sleeve length. I am trying to figure out a way to clear out any selections made based upon previous selection input if that input changes. For example: Short sleeve, pink shirt in size XS was selected. If the user were to go back and change it to long sleeve, I want the color and size selections to be cleared and require re-entry in case pink and XS are not applicable combinations for long sleeve shirts. (I'm not dealing with shirts, but this seemed like an easier explanation.) I previously utilized the below vba to do something similar, but it only cleared one cell dependent upon one other specified cell, not a range based upon any previous cell change in a range.
Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("e6")) Is Nothing Then
Range("e5").ClearContents
End If
End Sub
I would appreciate any assistance!
Thanks
Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("e6")) Is Nothing Then
Range("e5").ClearContents
End If
End Sub
I would appreciate any assistance!
Thanks