Here is some demo event code that should be installed in the worksheet code
area:
Private Sub Worksheet_Change(ByVal Target As Range)
Set t = Target
Messagee = Environ("username") & Chr(10) & Now
Application.EnableEvents = False
For Each r In t
r.NoteText Messagee
r.Comment.Visible = False
Next
End Sub
It will handle multiple cells as well as single cells. Because it is
worksheet code, it is very easy to install and use:
1. right-click the tab name near the bottom of the window
2. select View Code - this brings up a VBE window
3. paste the stuff in and close the VBE window
If you save the workbook, the macro will be saved with it.
To remove the macro:
1. bring up the VBE windows as above
2. clear the code out
3. close the VBE window
To learn more about macros in general, see:
http://www.mvps.org/dmcritchie/excel/getstarted.htm
To learn more about Event Macros (worksheet code), see:
http://www.mvps.org/dmcritchie/excel/event.htm
--
Gary''s Student - gsnu200832
"MikeZz" wrote:
Hi Gary,
Thanks for the reply.
I looked through some code I had in another workbook that did the single
cell tracking but to be quite honest....
It's rather bulky (with a lot more than what I need).
It's been a year since I looked at it.
It was created from a hodge-podge of sources.
I don't think I would be able to trim it down easily without screwing
something up.
Your comments sound simple enough...
What I suggest is that you loop through all the cells in Target (all the
cells that the Change Event sees as being changed)
But I have very little experience in using change events and could probably
waste a couple hours figuring how to do it. So, do you know an online source
which has the basic syntax and structure to go through what you suggested?
Or maybe a simple routine that I could modify for my purposes?
Thanks again for the feedback.
MikeZz
"Gary''s Student" wrote:
The problem with logging changes to block of cells, is that it also requires
blocks of cells to do the logging.
What I suggest is that you loop through all the cells in Target (all the
cells that the Change Event sees as being changed) and add/modify a comment
to include the username and date.
--
Gary''s Student - gsnu200831
"MikeZz" wrote:
Hi,
I know it's been hashed through a number of times with the answer that you
can't track multi-cell changes.
My question is if I can at least record who changed a cell and when... don't
need to know the old or new value... only that it was changed.
In my case, I have an excel workbook with about 15000 rows of data.
I have data in columns A through H.
If someone changes the value either in Columns C or D in row 1234, I want to
put their name in cell I-1234 with today's date in cell J-1234.
I can get it to work for single cell changes but want to know if it's
possible to do this tracking on multi-cell changes as well. Examples
being... copy and paste to many cells, drag down fills, etcl. The reason I
have hope someone can help is that I don't need to know the before and after
values.
Thanks for any help,
MikeZz