Thanks for the response. I actually used the following code:
Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Range)
If Not Intersect(Target, Range("B2:B3")) Is Nothing Then
The only problem with this code is that when the cell itself is select (i'm assuming because of Target) it clears the info in B4. This does work for me however, i was attempting to have B4:H4 cleared once the value in b2 changed.
e.g. the way it is now when activecell equals B2 or B3 it Clears contents.
I was looking for when a different selection was made from the drop down list in B2. Once the value was selected it would clear the contents in B4
you mean the list from Data Validation, then we will declare global variable “Before", & what you need will be done if you "Deactivet " & then " Activate“ the sheet where you make your selections.
Private Sub Worksheet_Activate()
Before = Range("B2").Value
Private Sub Worksheet_Change(ByVal Target As Range)
If Target = Range("B2") And Target <> Before Then Range("B4") = ""
Didn't work for me buddy. Upon entering the code it had no results. B4 contents don't clear at all. I don't know if this is a factor but in B2 it is a drop down list as well. once the drop down value is changed B4 should have it's contents cleared.