View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Charlie Charlie is offline
external usenet poster
 
Posts: 703
Default Event procedure for change of a particular cell?

The events you are looking for are in the individual sheets. The Open,
Close, etc. are in ThisWorkbook. Double-click the sheet you want, e.g.
"Sheet1" in the VBAProject--Microsoft Excel Objects folder.

"Chet" wrote:

Does anyone know of an event procedure (or code) that would enable a
piece of code to run upon the change of a particular cell on a
worksheet?

(I know there are event procedures for upon close, upon change, upon
calculate, etc but I only want to execute a piece of code when a
particular cell on my worksheet changes.).

Thanks,
Chet