C ces005 Board Regular Joined Mar 13, 2006 Messages 189 Oct 4, 2006 #1 Hi, I have a cell (D3). When the cell's value changes, I want a macro to be run. It is a picklist (data validation is tied to a list). How do I do this? Thanks. -Eileen
Hi, I have a cell (D3). When the cell's value changes, I want a macro to be run. It is a picklist (data validation is tied to a list). How do I do this? Thanks. -Eileen
P pgc01 MrExcel MVP Joined Apr 25, 2006 Messages 19,873 Oct 4, 2006 #2 Hi Eileen You can use the worksheet Change Event Paste this code in the respective worsheet module: Code: Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$D$3" Then ' run your code End If End Sub Add your code. Hope this helps PGC
Hi Eileen You can use the worksheet Change Event Paste this code in the respective worsheet module: Code: Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$D$3" Then ' run your code End If End Sub Add your code. Hope this helps PGC
C ces005 Board Regular Joined Mar 13, 2006 Messages 189 Oct 4, 2006 #3 Thanks a lot. That worked well.