Date/Time Stamping?

P

(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.
 
P

(PeteCresswell)

Per Paul B:
Pete, have a look here, http://www.mcgimpsey.com/excel/timestamp.html
Click to expand...

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.
 
G

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
 
Top