Matt Miller
asked on
Trying to Execute Macro when dropdown changes in Excel
I'm trying to have a macro run once a dropdown list has changed values but it doesn't seem to be working.
I've tried a couple of approaches with no luck.
Thanks,
I've tried a couple of approaches with no luck.
Thanks,
Option Explicit
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$B$1" Then
Range("B2").Value = ""
End If
End Sub
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
BTW what are you trying to achieve?
ASKER
Thank you very much. I just wanted to blank the cell because I'm using a data validation indirect and the list is dependent.
ASKER
Thank you very much. I'm surprised I was missing something so obvious.
You're welcome Mattfmiller! Glad your issue is resolved. :)