Excel VBA: How to track changed cells

J

Jens Lenge

Hello world,

I'd like to have an Excel 2003 VBA macro be automatically called each time
that the user changes the value of a cell (by either directly entering a new
value of using copy/paste).

* How can I make my macro be automatically called in such a case?
* How can I detect which cells was changed from inside the macro?

My macro should check the new cell value and change it under certain
conditions. In case the cell value is changed by my macro, is there a way to
prevent the macro from being called again for the same cell?

Jens
 
T

Tushar Mehta

Look at the worksheet's SelectionChange and Change events and the
application's EnableEvents property.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Multi-disciplinary business expertise
+ Technology skills
= Optimal solution to your business problem
Recipient Microsoft MVP award 2000-2005
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Drop down list control value in vba 2
VBA word change keys 0
Word macro that can call cells out of Excel for a find and replace 0
VBA Coding Help for Beginner 0
Avoiding tracked changes of existing tracked changes 1
Excel 2013: How to ensure a cell is not left blank by users? (Not using VBA) 0
Is there any way to reliably override change tracking actions in Word? 1
VBA for updating Resource's ActualWork 0

Top