Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
If statement for cell ranges to equivalent value | Excel Discussion (Misc queries) | |||
empty cell equivalent value | Excel Worksheet Functions | |||
Conversion of Cell Contents into a Functional Worksheet name ? | Excel Worksheet Functions | |||
Why, when I create workbook-level name does it jump it to Sheet-level ? | Excel Programming |