How to run function at any worksheet changes?

Chipcom

Registered User.
Local time
Today, 18:34
Joined
Apr 13, 2006
Messages
63
Hi

I need to know how to run function at any worksheet changes.
I tried to use :

Application.Volatile

Function example()

bla bla...........


End Function

But I getting the error: Invalid outside procedure.

Can you please tell me how to make it works?
When I remove Application.Volatile the function runs but only when I push the run button

Thanks
 
Last edited:
Open the individual worksheet code window and go to the ThisWorksheet Change event.

excel1.png
 
Thanks

But How I define when specific cell was chaged and not by selection ?
 

Users who are viewing this thread

Back
Top Bottom