How to catch event of modifying text in a range object?

[Joerg Eisentraeger]

Hello all,

I want to run a sub when the text of a defined range is modified.

Especially I want to update a bookmark text when the text of a cell in
column1 of table 1 is changed. How to catch the event of modifying text
in column 1?

Thanks for all answers.

Greatings from Germany
Joerg

 

[Helmut Weber]

Hi Joerg,
so far I haven't heared of a range.text.change event,
and I can't find one in the object library. However,
if it's worth the effort and the implicated complications,
you could set up an ontime macro, that stores the text in
the range somewhere and checks whether is has changed in
certain intervalls. I'd suggest, you use a reference-field instead.
{ REF BookmarkName }
Greetings from Bavaria, Germany
Helmut Weber, MVP
"red.sys" & chr(64) & "t-online.de"
Word XP, Win 98