question about triggering macro when value of cell changes

ces005

Board Regular
Joined
Mar 13, 2006
Messages
189
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
 

Some videos you may like

Excel Facts

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.

pgc01

MrExcel MVP
Joined
Apr 25, 2006
Messages
19,873
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
 

Watch MrExcel Video

Forum statistics

Threads
1,118,297
Messages
5,571,401
Members
412,387
Latest member
qxyy
Top