Capturing cell change event - from cell edit, paste and as a result of formula

O

OrlaH

I need to capture when a spreadsheet cell value gets changed. I'm
currently using the EndEdit event with success, but now I need to
capture -
1. Cell value changes as a result of the user pasting in new values.
2. Cell with a formula changed as a result of any of it's dependents
changing.

The EndEdit event does not seem to capture these.

I've tried using the SheetChange event but that keeps crashing my
browser and though it (the SheetChange event) seems to realise the
paste changes does not seem to capture the formula scenario.

Any help would be welcome.

Thanks in advance.

Orla
 

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

External cell reference between two excel worksheets both in One Drive 0
Cell content change Event 7
Change Log with prior and new values 1
OWC Spreadsheet events do crash IE6 5
Validate the Formula calculated cell 0
Capture Worksheet Change Value 1
Avoid protected cell warning on BeforeDoubleClick WS event 2
Can't get desired event to capture user entry on user form in vba app 1

Top