[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

RE: EXCEL w/ TS



PureBytes Links

Trading Reference Links

Hi,
You have to write your own custom formula or procedure using vba. Take a
look at the Change event of the worksheetobject - If certain cells change,
put a timestamp in the appropriate cell.


Regards
Jonas

> -----Original Message-----
> From: Gerald Marisch [mailto:gm@xxxxxxxxxxxxx]
> Sent: den 19 februari 1999 17:58
> To: Omega list
> Subject: EXCEL w/ TS
>
>
> I'm using an Excel Spreadsheet with TS.
>
> For one cell, I would like the time to be automatically
> entered when another
> cell (the "Fill Cell") has a value >0.
> Further, I would like to "lock in" this time.
>
> The IF conditional and "NOW()" works, but the time does not stop.
>
> Anyone have an idea??????
>
>
>