how to get the time
 

how do I get the time on a column when a signature or a name is on another
column. For example on column B I need the time, when column A is filled.
please help

how to get the time
 

Hi,

Since you are in the Chart forum, are you talking about charts or
spreadsheet cells?

If spreadsheet cells, you will need to use vba unless you can get the user
to type in the time. The shortcut key for entering the current time in a
cell is Ctrl+: (ctrl color - shifted semi-colon)

VBA:

Private Sub Worksheet_Change(ByVal Target As Range)
Dim isect As Range
Set isect = Intersect(Target, Range("A1:A100"))
If Not isect Is Nothing Then
Target.Offset(0, 1) = Time
End If
End Sub

This needs to be in the Sheet object for the sheet you are applying this to,
such as Sheet1

Press Alt+F11, and double click the appropriate sheet under your workbook
name in the Project window at the top left. Put the code in the code sheet
to the right.

--
Thanks,
Shane Devenshire


"Eduardo" wrote:

how do I get the time on a column when a signature or a name is on another
column. For example on column B I need the time, when column A is filled.
please help

how to get the time
 

correct I'm creating a spreadsheet
but I'm looking for a formula that inserts automatically the current time on
column B when I enter a text on column A

is that possible?

thanks for reply!!
"ShaneDevenshire" wrote:

Hi,

Since you are in the Chart forum, are you talking about charts or
spreadsheet cells?

If spreadsheet cells, you will need to use vba unless you can get the user
to type in the time. The shortcut key for entering the current time in a
cell is Ctrl+: (ctrl color - shifted semi-colon)

VBA:

Private Sub Worksheet_Change(ByVal Target As Range)
Dim isect As Range
Set isect = Intersect(Target, Range("A1:A100"))
If Not isect Is Nothing Then
Target.Offset(0, 1) = Time
End If
End Sub

This needs to be in the Sheet object for the sheet you are applying this to,
such as Sheet1

Press Alt+F11, and double click the appropriate sheet under your workbook
name in the Project window at the top left. Put the code in the code sheet
to the right.

--
Thanks,
Shane Devenshire


"Eduardo" wrote:

how do I get the time on a column when a signature or a name is on another
column. For example on column B I need the time, when column A is filled.
please help