| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
now function not to update
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:))) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| now function not to update | Excel Discussion (Misc queries) | |||
| Don't Update Function | Excel Discussion (Misc queries) | |||
| function update | Excel Worksheet Functions | |||
| Auto Update Function | Excel Discussion (Misc queries) | |||
| Function Update | Excel Worksheet Functions | |||
Threaded Mode
