Worksheet_Change Event triggered off specific cell

E

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
 
R

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 *
 
M

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
 
Top