Solved: display time

[rav_x06]

Hi, i have this fuction (=now() this display date and time)in cell but it dont update, i want it to display the time only which autoupdate and displays the seconds as well.

Thanks

[mperrah]

Do you want an update every second or minute,
or just a one time update,
you can trigger the update by several events...
click, cell content change, focus change, load sheet etc...
The key is how often you need it updated,
once or ongoingly

[Bob Phillips]

See http://xldynamic.com/source/xld.XtraTime.html

[rav_x06]

Hi, Thanks it working just one more question , the timer is set on the button so I changed it to the Private Sub Worksheet_Activate() but the timer start when I switcht to that, I want as like when the file is open the timer starts, any ideas.

Thanks

[Bob Phillips]

Put in Workbook_Open event procedure then.

[rav_x06]

Put in Workbook_Open event procedure then.

hi i tried this before I should have mentioned it but it dont work the worksheet is called interface and it the first sheet that open when the file is opened in excel.

Thanks

[Bob Phillips]

Did you put Workbook_Open in the Thisworkbook code module?

[rav_x06]

Did you put Workbook_Open in the Thisworkbook code module?

Hi, fixed it

Thanks

[Bob Phillips]

This is workbook event code.
To input this code, right click on the Excel icon on the worksheet
(or next to the File menu if you maximise your workbooks),
select View Code from the menu, and paste the code

[rav_x06]

hi thanks it works perfectly

Thanks alot

[lucas]

Please mark your thread solved using the thread tools at the top of the page...