|
|
Show date in cell if data changes |
|
Author |
Message |
Steve80
|
Posted: Sat May 01 06:29:39 CDT 2004 |
Top |
Excel Programming >> Show date in cell if data changes
Hi folks, not sure if this is the right forum (maybe worksheet functions?)
Basically I have a worksheet in which I enter scores, and from this produce
a table.
I would like to display in a cell below the scores matrix, a date when I
enter new scores - IE so that I can keep track of when I last updated the
scores matrix.
Possible?
Thanks
Neil
Excel204
|
|
|
|
|
Frank
|
Posted: Sat May 01 06:29:39 CDT 2004 |
Top |
Excel Programming >> Show date in cell if data changes
Hi
have a look at
http://www.mcgimpsey.com/excel/timestamp.html
--
Regards
Frank Kabel
Frankfurt, Germany
> Hi folks, not sure if this is the right forum (maybe worksheet
> functions?)
>
> Basically I have a worksheet in which I enter scores, and from this
> produce a table.
>
> I would like to display in a cell below the scores matrix, a date
> when I enter new scores - IE so that I can keep track of when I last
> updated the scores matrix.
>
> Possible?
>
> Thanks
> Neil
|
|
|
|
|
Neil
|
Posted: Sun May 02 17:56:50 CDT 2004 |
Top |
Excel Programming >> Show date in cell if data changes
Thanks
I looked at the page, and tried adapting your Alternate 2 to this
Private Sub Worksheet_Change(ByVal Target As Excel.Range)
With Target
If .Count > 1 Then Exit Sub
If Not Intersect(Range("B2:U11"), .Cells) Is Nothing Then
Application.EnableEvents = False
With .Cells(14, 1)
.NumberFormat = "dd mmm yyyy"
.Value = Date
End With
Application.EnableEvents = True
End If
End With
End Sub
However, this just puts a date in 14, 1 offset from EVERY change I make in
the area B2:U11
What I actually want, is only one date to be displayed for any changes made
in that area in Cel A14 ONLY.
I'm not really any good with vbs. Can anyone suggest a mod to make it work
please.
I'll search the archievs meantime to see if I can work it out
Thanks
Neil
> Hi
> have a look at
> http://www.mcgimpsey.com/excel/timestamp.html
>
> --
> Regards
> Frank Kabel
> Frankfurt, Germany
>
>
> > Hi folks, not sure if this is the right forum (maybe worksheet
> > functions?)
> >
> > Basically I have a worksheet in which I enter scores, and from this
> > produce a table.
> >
> > I would like to display in a cell below the scores matrix, a date
> > when I enter new scores - IE so that I can keep track of when I last
> > updated the scores matrix.
> >
> > Possible?
> >
> > Thanks
> > Neil
|
|
|
|
|
Dave
|
Posted: Sun May 02 18:09:09 CDT 2004 |
Top |
Excel Programming >> Show date in cell if data changes
So if you change anything in B2:U11, then you want to change A14?
If yes, then change this:
With .Cells(14, 1)
to
With me.Cells(14, 1)
the me refers to the worksheet that owns the code--so it'll always points at
A14.
>
> Thanks
>
> I looked at the page, and tried adapting your Alternate 2 to this
> Private Sub Worksheet_Change(ByVal Target As Excel.Range)
> With Target
> If .Count > 1 Then Exit Sub
> If Not Intersect(Range("B2:U11"), .Cells) Is Nothing Then
> Application.EnableEvents = False
> With .Cells(14, 1)
> .NumberFormat = "dd mmm yyyy"
> .Value = Date
> End With
> Application.EnableEvents = True
> End If
> End With
> End Sub
>
> However, this just puts a date in 14, 1 offset from EVERY change I make in
> the area B2:U11
> What I actually want, is only one date to be displayed for any changes made
> in that area in Cel A14 ONLY.
> I'm not really any good with vbs. Can anyone suggest a mod to make it work
> please.
> I'll search the archievs meantime to see if I can work it out
>
> Thanks
> Neil
> > Hi
> > have a look at
> > http://www.mcgimpsey.com/excel/timestamp.html
> >
> > --
> > Regards
> > Frank Kabel
> > Frankfurt, Germany
> >
> >
> > > Hi folks, not sure if this is the right forum (maybe worksheet
> > > functions?)
> > >
> > > Basically I have a worksheet in which I enter scores, and from this
> > > produce a table.
> > >
> > > I would like to display in a cell below the scores matrix, a date
> > > when I enter new scores - IE so that I can keep track of when I last
> > > updated the scores matrix.
> > >
> > > Possible?
> > >
> > > Thanks
> > > Neil
--
Dave Peterson
|
|
|
|
|
|
|