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

What causes the cell to change value?

--
Regards,
Tom Ogilvy


"bondcrash" wrote
in message ...

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

Why not use the Change event ?

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

Ric

--
Rich_
-----------------------------------------------------------------------
Rich_z's Profile: http://www.excelforum.com/member.php...fo&userid=2473
View this thread: http://www.excelforum.com/showthread.php?threadid=38678

Worksheet change can monitor many cells.

--

HTH

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


"bondcrash" wrote
in message ...

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

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


--
bondcrash
------------------------------------------------------------------------
bondcrash's Profile: http://www.excelforum.com/member.php...o&userid=20997
View this thread: http://www.excelforum.com/showthread...hreadid=386781

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

regards

Ric

--
Rich_
-----------------------------------------------------------------------
Rich_z's Profile: http://www.excelforum.com/member.php...fo&userid=2473
View this thread: http://www.excelforum.com/showthread.php?threadid=38678

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


--
bondcrash
------------------------------------------------------------------------
bondcrash's Profile: http://www.excelforum.com/member.php...o&userid=20997
View this thread: http://www.excelforum.com/showthread...hreadid=386781