LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
If statement for cell ranges to equivalent value Rechie Excel Discussion (Misc queries) 2 September 1st 09 09:58 AM
empty cell equivalent value DonJ-Austin Excel Worksheet Functions 3 December 20th 05 05:26 AM
Conversion of Cell Contents into a Functional Worksheet name ? GMJT Excel Worksheet Functions 1 August 21st 05 04:59 PM
Why, when I create workbook-level name does it jump it to Sheet-level ? Charles Jordan Excel Programming 1 November 5th 03 08:43 PM


All times are GMT +1. The time now is 11:46 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"