Function to capture the time a cell changes

Hi all... I am trying to build a function that freezes the time when another cell changes its value. I don't want to use a Worksheet Calculate or a Selection Change because i have several cells to monitor and all the cells have the same priority. I am frankly a little stuck.

Anyone has any suggestion or maybe used something similar in the past?

Many thanks

BC

Why not use the Change event ?

Do you need the time down to the absolute second ? I would think that several changes would rattle through the event in less than that.

Rich

Thanks Rich - I was a little put off by the fact that i have to do it for some forty cells and maybe a function was more efficient. but yes a worksheet change would do

cheers

BC

Well, you would be using a subroutine, and the worksheet change event passes you the address of the cell that has changed.....

regards

Rich

What causes the cell to change value?

--
Regards,
Tom Ogilvy


"bondcrash" <[email protected]> wrote
in message news:[email protected]...
>
> Hi all... I am trying to build a function that freezes the time when
> another cell changes its value. I don't want to use a Worksheet
> Calculate or a Selection Change because i have several cells to monitor
> and all the cells have the same priority. I am frankly a little stuck.
>
> Anyone has any suggestion or maybe used something similar in the past?
>
> Many thanks
>
> BC
>
>
> --
> bondcrash
> ------------------------------------------------------------------------
> bondcrash's Profile:
http://www.excelforum.com/member.php...o&userid=20997
> View this thread: http://www.excelforum.com/showthread...hreadid=386781
>

Worksheet change can monitor many cells.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"bondcrash" <[email protected]> wrote
in message news:[email protected]...
>
> Hi all... I am trying to build a function that freezes the time when
> another cell changes its value. I don't want to use a Worksheet
> Calculate or a Selection Change because i have several cells to monitor
> and all the cells have the same priority. I am frankly a little stuck.
>
> Anyone has any suggestion or maybe used something similar in the past?
>
> Many thanks
>
> BC
>
>
> --
> bondcrash
> ------------------------------------------------------------------------
> bondcrash's Profile:
http://www.excelforum.com/member.php...o&userid=20997
> View this thread: http://www.excelforum.com/showthread...hreadid=386781
>

the cells are linked to other cells. their status is empty, unless they change. when they do they trigger a worksheet calculate and go immediately back to empty. problem is, i have some 50 of them and when a work sheet calculate is triggered at times i dont know which cell does trigger it.

problem is, i have tried a selection change code for all the 50 cells but this make the machine very slow and clashes with other macros.

ideally i think i would need to create a function (add-in). hmmm

BC