Vba add time based on cell and fill formula

[Zaeguzah]

Hi guys. Old problem but new question. In the vba within workbook below I would like to add into it several things:

• each time I write something in column "c", column "b" must be filled with the actual time (- 15 sec). However, If I

were to delete a cell in column "C" then the time In "b" would also have to be deleted. Accept only text cells and

start from row 5 and downwards.


• if time exists in "b" then fill this formula

Please Login or Register  to view this content.

in column "g". Where "bookpath" is a udf.

Please Login or Register  to view this content.

[JeanRage]

Hi,

See attached ...

HTH

[Zaeguzah]

Perfect. Thanks my friend. One more thing if you have the time.. If I select a cell at a time in column "C" the time and the formula gets deleted. Fine but if I select a range from column "C", ie: C5:C20 for instance then nothing gets deleted. Any possble fix for this?

Thanks for your help,
Alex

[JeanRage]

Hi,

Adjust the range to your needs ...

Please Login or Register  to view this content.

HTH

[Zaeguzah]

Thanks man. Like a charm as always. SOLVED