question about triggering macro when value of cell changes

[ces005]

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

 

[pgc01]

Hi Eileen

You can use the worksheet Change Event

Paste this code in the respective worsheet module:

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

 

[ces005]

Thanks a lot. That worked well.