AfterUpdate functional equivalent at Cell level?
If you take everything I know about Excel, roll it up into a ball, and
set it on the edge of a razorblade; it will look roughly like a
golfball in the middle of the New Jersey Turnpike...so cut me a little
slack here.
The larger question is: "How to track changes to a given cell". i.e.
if somebody edits a cell, we want to capture their
userid/name/whatever, a timestamp, and the value that was replaced.
Scanning a Google search on "Excel AfterUpdate", it looks like dealing
directly with the cells would be fighting Mother Nature.
True?
Seems like there is something called a UserForm and a TextBox.
Sounds like the strategy for allowing users to update cells and track
changes to same would involve making them go through a "UserForm" and
"TextBox" to make the changes.
True?
If not, what would the preferred strategy be?
|