to execute a macro when any cell value changes

Feb 26th, 2002, 02:49 PM

Can anyone tell me the codes that will execute an already existing macro when any cell value is changed in the worksheet. I think it uses Change event but I can figure out the exact codes. How would private sub affect my macro?

Thanks
VS

Tommy Bak · Feb 26th, 2002, 03:06 PM

try this one. click on the sheet tab, ´click view code and paste it

Private Sub Worksheet_Change(ByVal Target As Range)
Call anothermacro
End Sub

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 26th, 2002, 02:49 PM	#1
Guest Posts: n/a	Can anyone tell me the codes that will execute an already existing macro when any cell value is changed in the worksheet. I think it uses Change event but I can figure out the exact codes. How would private sub affect my macro? Thanks VS

Feb 26th, 2002, 03:06 PM	#2
Tommy Bak Board Regular Join Date: Feb 2002 Location: Guderup, Denmark Posts: 287	try this one. click on the sheet tab, ´click view code and paste it Private Sub Worksheet_Change(ByVal Target As Range) Call anothermacro End Sub