Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Show time stamp when a value is entered
I use a scanner in my classroom to record attendance. Students highlight the
cell next to their name on a roster then scan their ID. It enters their ID number in the cell. I would like the time the card was scanned to show up instead. I played around with the If and Now formulas but could not get it to work. I'm thinking of a macro that whenever any value is entered in the cell it shows time instead. Any ideas? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Show time stamp when a value is entered
Here the way using the IF and NOW() functions
Cells used A1 & B1 where A1 is the result of the scanner and B1 is your formula. =If(A1<0,Now(),"") This will work if you don't mind having another column. TVCCBJB wrote: I use a scanner in my classroom to record attendance. Students highlight the cell next to their name on a roster then scan their ID. It enters their ID number in the cell. I would like the time the card was scanned to show up instead. I played around with the If and Now formulas but could not get it to work. I'm thinking of a macro that whenever any value is entered in the cell it shows time instead. Any ideas? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Show time stamp when a value is entered
Perhaps something like this. This a sheet macro and must be placed in the
sheet module of your sheet. As written, this macro will change any entry made in Column B, in any row greater than 1, to the current system time. HTH Otto Private Sub Worksheet_Change(ByVal Target As Range) If Target.Count 1 Then Exit Sub If IsEmpty(Target.Value) Then Exit Sub If Target.Column = 2 And _ Target.Row 1 Then Target.Value = Time End Sub "TVCCBJB" wrote in message ... I use a scanner in my classroom to record attendance. Students highlight the cell next to their name on a roster then scan their ID. It enters their ID number in the cell. I would like the time the card was scanned to show up instead. I played around with the If and Now formulas but could not get it to work. I'm thinking of a macro that whenever any value is entered in the cell it shows time instead. Any ideas? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Show time stamp when a value is entered
here is one idea
if thesstudents name is in columna Id numbers are entered in Col B and you want date/time in Col C add this macro to the worksheet thorugh the VBeditor Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column = 2 Then Target.Offset(0, 1).Value = Date & " " & time End Sub TVCCBJB wrote: I use a scanner in my classroom to record attendance. Students highlight the cell next to their name on a roster then scan their ID. It enters their ID number in the cell. I would like the time the card was scanned to show up instead. I played around with the If and Now formulas but could not get it to work. I'm thinking of a macro that whenever any value is entered in the cell it shows time instead. Any ideas? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Show time stamp when a value is entered
This will update every time the sheet is re-calculated.
I believe OP wants a static time. See Otto's post. Gord Dibben MS Excel MVP On 8 Sep 2006 12:43:24 -0700, "Sandy" wrote: Here the way using the IF and NOW() functions Cells used A1 & B1 where A1 is the result of the scanner and B1 is your formula. =If(A1<0,Now(),"") This will work if you don't mind having another column. TVCCBJB wrote: I use a scanner in my classroom to record attendance. Students highlight the cell next to their name on a roster then scan their ID. It enters their ID number in the cell. I would like the time the card was scanned to show up instead. I played around with the If and Now formulas but could not get it to work. I'm thinking of a macro that whenever any value is entered in the cell it shows time instead. Any ideas? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Time & Date Stamp 2 worksheets | Excel Discussion (Misc queries) | |||
Using Date & Time Custom Cell - Need to show blank! | Excel Discussion (Misc queries) | |||
numbers being entered show in formula bar but not in cell? | Excel Discussion (Misc queries) | |||
How do I make a time Stamp in excel? | Excel Discussion (Misc queries) | |||
Time Stamp without change | Excel Discussion (Misc queries) |