Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
get date with now() today() but dont update with recalc
is there a way to stop a cell being recalculated when useing the now()
function ? e.g if(a1="order",c1=now(),"")....but i dont want the cell updated after its inital value is obtained. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
get date with now() today() but dont update with recalc
This Change-event macro will put the date in C1 when "order" is typed in A1
and the "Enter" key is pressed. Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range) If Range("a1").Value = "order" Then Range("c1").Value = Date End If End Sub Vaya con Dios, Chuck, CABGx3 "robert w" <robert wrote in message ... is there a way to stop a cell being recalculated when useing the now() function ? e.g if(a1="order",c1=now(),"")....but i dont want the cell updated after its inital value is obtained. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I create a schedule from a list of dates ? | Charts and Charting in Excel | |||
How to automtcly update th date in cell if info in row changes? | Excel Discussion (Misc queries) | |||
go to cell with date equaling TODAY() | Excel Discussion (Misc queries) | |||
Automatic Date Update | Excel Discussion (Misc queries) | |||
Today() or Date() function help | Excel Discussion (Misc queries) |