Date/Time Stamping?

[(PeteCresswell)]

I'd like to be able to automagically enter the date/time.
Either into separate cells (one for date another for time) or into a single
cell.

Nothing complicated - just keeping a list of network response time tests. First
column(s) will be Date/Time, the other column will be KBPS.

I can do VBA, just don't know where to start.

 

[Paul B]

Pete, have a look here, http://www.mcgimpsey.com/excel/timestamp.html
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

 

[(PeteCresswell)]

Per Paul B:

Pete, have a look here, http://www.mcgimpsey.com/excel/timestamp.html

That was quick.

Looks like just the ticket.

Thanks!

 

[(PeteCresswell)]

Per Paul B:

Pete, have a look here, http://www.mcgimpsey.com/excel/timestamp.html

Not to turn into a tarbaby on you... but...

Once I assign that macro to a custom button, how do I feed it the address of the
currently-active cell?

I tried

VerizonSpeedTestResults.xls'!DateTimeStamp(Excel.Application.ActiveCell)

but it's telling me "macro not found..."

OTOH if I just feed it

VerizonSpeedTestResults.xls'!DateTimeStamp()

it gets to the macro but, of course, the macro dies on the
missing argument.

 

[Gord Dibben]

Pete

The code from J.E.'s site is worksheet event code and not designed to be
assigned to a button.

It runs off an event change.

Right-click your sheet tab and "View Code"

Copy/paste the code from J.E.'s site into that sheet module.


Gord Dibben MS Excel MVP