Hi Rick, out of curiosity, how do you detect the keystroke so that you can
tell that the change was not the result of code execution? Or did you have a
different method in mind?

"Rick Rothstein" wrote:

The answer to your question is yes but, in order to give you code, we will
need more information. Is this functionality to be confined to a single
worksheet or do you want to track changes on any worksheet and perform the
Column B update on the worksheet where the change was made? Do you want the
update in Column B to take place automatically as soon as the cell is
changed (which would use an event procedure and not a macro) or only when
you execute a macro manually? Are there certain columns that you want to
track (if so, which ones) or do you want to track changes to any column
(other than Column B, I would guess)? What is the update that you want to
perform in Column B?

--
Rick (MVP - Excel)


wrote in message
...
Is it possible for VB to determine the last cell that was changed. I'm
not referring to a cell changed by a macro, just a cell that was
changed by typing into the cell. I want a macro to then update a cell
in the same row, column B.

Thanks