Starting a macro by editing a cell

Y

Yiannis

I would like a macro to be initiated whenever someone edits a particula
cell, does anyone now how this can be done?

Many Thanks,

Yianni
 
J

jeff

Try something like this in your Worksheet_Change or
Worksheet_SelectionChange :

If Target.Cells.Count > 1 Then Exit Sub
If Not Application.Intersect(Range("A1:A1"), Target) Is
Nothing Then runMyMacro

jeff
 
D

Dave Peterson

And the worksheet_change events fire when the user finishes editting the cell.

The worksheet_selectionchange event fires when the user selects that cell.
 
Top