View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
PeteCresswell PeteCresswell is offline
external usenet poster
 
Posts: 2
Default 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?