Auto update clock

[arshad_masud]

Is there any formula which automatically updates =now() formula without pressing f9

 

[vijaySharma]

Arshad,


No formula for this... though can be done using VBA code.


If you can specify your requirement it would be helpful... like do you want to display a clock on the sheet? or autocalculate?


~Vijay

 

[arshad_masud]

Dear Vijay


Thanks for the response. Yes i want to display a clock in the sheet and i want the worksheet to auto calculate.

 

[vijaySharma]

Dear Arshad,


I have created the example worksheet for your.


It contains Timer with Sub-Classing code (which is not written by me and I dont own that).


If you could send me a sample mail on sharma.vijay1-at-gmail.com I will mail the excel file to you.


Though, I would not recommend this activity of displaying time on the sheet.


~Vijay

 

[arshad_masud]

Dear Vijay


I have sent you a test mail on your given address.


Many thanks

 

[vijaySharma]

Dear Arshad,


I have mailed the file over to you.


~Vijay

 

[arshad_masud]

Dear Vijay


I am really grateful to your for your great effort.


Regards


Arshad

 

[vijaySharma]

Glad I could be of Help.... cheers

 

[arshad_masud]

Hi Vijay


Can you guide me how did you do that. Is it in VBA or something else.


Thanks

 

[vijaySharma]

Dear Arshad,


As stated earlier; there is a Class module which creates the Timer and allow you to use.


Yes, it is in the VBA code.


~Vijay

 

[arshad_masud]

Many thanks