vba timer

[Undo]

Hello

i user this code for timer in my excel

Please Login or Register  to view this content.

and StartBtn_Click in workbook open sub

if i save and close the file, when i open it the timer start from zero
how can i keep it continue ?

thanks

[MarvinP]

Hi e97h,

You could write a time to a cell in one of your worksheets using an On_Close event. Then when you open your workbook you could read that number to start the timer again from a non zero time.

If you don't want to use a cell in the workbook, how about using the Tag property in one of your objects and store the closing time there and read it on open?

Just some ideas...

Marv

[Undo]

first point is better
but how should i do it? can u help
i do it but after i open the excel, its stuck in 00:00:00

[Undo]

This the excel file if anyone can help

thanks

[MarvinP]

Hi e97h,

See my example attached. See if it does what you need. I tried to make it as simple as possible.

Total Time Workbook Open Timer.xlsm

[Undo]

Thank for help, but its not working
kindly insert it my sample excel