When cell changes, execute code

**kirkland** · 02-15-2012, 05:29 AM

^I've tried that and nothing seems to be happening. I've even tried putting

msgbox "helloworld"

instead of my code and nothing

Is the location of the Private Sub Worksheet_Change(ByVal Target As Range) important?
Also, the sheet that J26 is called "Phase II" does that change anything?

**tom1977** · 02-15-2012, 06:48 AM

Of course the place of code is important You should have it in sheet's module (mark the name of sheet and clik right key of mouse and choose "view code" and there place it) and the name of sheet has nothing to do with working of this code

**kirkland** · 02-15-2012, 09:06 AM

Ahhh, I put it in the same sheet, but that wasn't the issue. It wasn't recognizing when the cell was changing (I had it linked to another equation, and when the equation changed, it wouldn't execute my function).

but I found a way around it now. thank you so much!