-
Solved: Change event simply not working
Okay, I give up. I've scowered the internet, I've copied from previously written code that I know for sure works and I still can't get this simple change event to move an inch.
It's like it's not even there in the worksheet code...
[VBA]
Private Sub Worksheet_Change(ByVal Target As range)
If Target.Address = "$C$7" Then
Sheets("Revenue Dashboard").range("B1") = "=vlookup(C7,'dropdowns'!J:K,2,0)"
End If
End Sub
[/VBA]
C7 is a drop down of month names, B1 is the trigger for a series of formulas that present information, B1 is also linked to a scrollbar which can also adjust the months. I've removed the scrollbar to see if that was the issue, it's not.
Something ain't right!!
Any ideas??
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules