On Sep 25, 6:45*pm, baha wrote:
On Sep 25, 6:36*pm, baha wrote:





On Sep 25, 6:22*pm, Stefi wrote:

You need an event macro to do that:

Private Sub Worksheet_Change(ByVal Target As Range)
* * If Target.Column = 1 Then * 'Column A
* * * * Range("B" & Target.Row) = Time
* * End If
End Sub

Post if you need help to install it!

Regards,
Stefi
„baha” ezt írta:

Hi,
First of all I search for smilar question but could not get any
answer,if this is duplucated question,please accept my appoligies.
I have a spread sheet which looks like a log file.What I want to do
is, when I enter a number in a cell in A coloumn, to display the time
in column B.I tried now,but when the next number entered in column A
it all change the entire colum B.I haveother formulas,so that I cannot
chose manual calculations options.
Thanks for your help.
Baha- Hide quoted text -

- Show quoted text -

Hi Stefi,
Thanks for the reply,how do I put that macro?In the sheet or this
workbook?Or honestly I don't know how to run that that macro ?
Thank you very much for the help
baha- Hide quoted text -

- Show quoted text -

Thank you Feli I managed to do that.Thank you very much for the help
Have a good weekend
Baha- Hide quoted text -

- Show quoted text -

I mean Stefi(this keyboard kills me:)))