Worksheet_Change Event triggered off specific cell

[ExcelMonkey]

I know how to use Worksheet Change events. But I do not know how t
trigger them off a specific cell. The following works off a change i
any cell.

Sub Worksheet_Change(ByVal Target As Excel.Range)

Call ProcedureA

End Sub

How do I edit this so that is triggers off a specific cell?

Thank

 

[Rob Bovey]

See my answer to your question below.

--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *

 

[mudraker]

ExcelMonkey

You can not have it trigger off a particular cell.

You need to test the target.address


if target.address ="$A$1" then
do something
end if

also look at using Intersect to test your targe