now function not to update
 

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

now function not to update
 

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

now function not to update
 

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

now function not to update
 

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

now function not to update
 

Open VBA (Alt+F11)!
Right click on your worksheet name in the Project explorer window!
Select View code from the popup menu!
Copy/Paste macro code in the code window!

Thre is no need for any further actions, the event macro shall be triggered
automatically whenever you enter data in column A.


Regards,
Stefi

€žbaha€� ezt Ã*rta:

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

now function not to update
 

You are welcome! Thanks for the feedback!
Stefi
Clicking the YES button will be appreciated.



€žbaha€� ezt Ã*rta:

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