View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Rob Bovey Rob Bovey is offline
external usenet poster
 
Posts: 811
Default Worksheet_Change Event triggered off specific cell


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 *


"ExcelMonkey " wrote in message
...
I know how to use Worksheet Change events. But I do not know how to
trigger them off a specific cell. The following works off a change in
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?

Thanks


---
Message posted from http://www.ExcelForum.com/