While day trading I'm required to keep a time log when each trade has been
executed.

How nice. Do you have a question?

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Day Trader" <Day wrote in message
...
While day trading I'm required to keep a time log when each trade has been
executed.

"Don Guillett" wrote:

How nice. Do you have a question?

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Day Trader" <Day wrote in message
...
While day trading I'm required to keep a time log when each trade has been
executed.

In column E, I will be inputing trades that are executed throughout the day. For each trade I need to time stamp what time such trade was executed in column F.

It sounds like you want an automatic time stamp, but you said you
wanted to track the time the trade was executed, so I don't see how
Excel would get that info.
If you want to have the current time go into a cell you can type
[Ctrl]: (that is [Ctrl][Shift];).

On May 29, 10:22 am, Day Trader
wrote:
"Don Guillett" wrote:
How nice. Do you have a question?

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Day Trader" <Day wrote in message
...
While day trading I'm required to keep a time log when each trade has been
executed.

In column E, I will be inputing trades that are executed throughout the day. For each trade I need to time stamp what time such trade was executed in column F.

right click sheet tabview codeinsert thissave
Now when you enter something in col F the time will show in col G

Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, Range("f2:f200")) Is Nothing Then Exit Sub
Target.Offset(, 1) = Time
End Sub

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Day Trader" wrote in message
...


"Don Guillett" wrote:

How nice. Do you have a question?

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Day Trader" <Day wrote in message
...
While day trading I'm required to keep a time log when each trade has
been
executed.

In column E, I will be inputing trades that are executed throughout the
day. For each trade I need to time stamp what time such trade was
executed in column F.

"Don Guillett" wrote:

right click sheet tabview codeinsert thissave
Now when you enter something in col F the time will show in col G

Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, Range("f2:f200")) Is Nothing Then Exit Sub
Target.Offset(, 1) = Time
End Sub

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Day Trader" wrote in message
...


"Don Guillett" wrote:

How nice. Do you have a question?

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Day Trader" <Day wrote in message
...
While day trading I'm required to keep a time log when each trade has
been
executed.

In column E, I will be inputing trades that are executed throughout the
day. For each trade I need to time stamp what time such trade was
executed in column F.

I right click on Sheet 1
Then click on view code

Once in view code where do I type in save?

Please TOP post for me
save the workbook....

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Day Trader" wrote in message
...


"Don Guillett" wrote:

right click sheet tabview codeinsert thissave
Now when you enter something in col F the time will show in col G

Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, Range("f2:f200")) Is Nothing Then Exit Sub
Target.Offset(, 1) = Time
End Sub

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Day Trader" wrote in message
...


"Don Guillett" wrote:

How nice. Do you have a question?

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Day Trader" <Day wrote in message
...
While day trading I'm required to keep a time log when each trade
has
been
executed.

In column E, I will be inputing trades that are executed throughout
the
day. For each trade I need to time stamp what time such trade was
executed in column F.

I right click on Sheet 1
Then click on view code

Once in view code where do I type in save?