Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Working with the now function.
I am using the following code to put the current time in column c when I type a riders number into column a. What I would like to be able to do is to change the code so that if there is already a value in column a, I can change it (like in the case of a typo that needs fixing) I can without the time getting updated again. Private Sub Worksheet_Change(ByVal Target As Range) If Not Application.Intersect(Target, Columns("B:B")) Is Nothing Then Target.Offset(0, 1).Value = Format(Now, "h:mm:ss") End If End Sub Thanks again. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ISBLANK function not working when cell is blank dut to function re | Excel Discussion (Misc queries) | |||
RIGHT function not working | Excel Discussion (Misc queries) | |||
Newly created Get Function is not working when I copied the syntax from a working function | Excel Programming | |||
Working with Arrays, pasing from function to function | Excel Programming | |||
Function F3 key not working | Excel Worksheet Functions |