PDA

View Full Version : Solved: display time



rav_x06
10-25-2007, 11:14 AM
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
10-25-2007, 01:45 PM
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
10-25-2007, 01:58 PM
See http://xldynamic.com/source/xld.XtraTime.html

rav_x06
10-26-2007, 06:37 AM
Hi, Thanks it working just one more question :cool:, 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
10-26-2007, 07:22 AM
Put in Workbook_Open event procedure then.

rav_x06
10-26-2007, 08:21 AM
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
10-26-2007, 08:27 AM
Did you put Workbook_Open in the Thisworkbook code module?

rav_x06
10-26-2007, 09:17 AM
Did you put Workbook_Open in the Thisworkbook code module?
Hi, fixed it

Thanks

Bob Phillips
10-26-2007, 09:19 AM
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
10-26-2007, 09:30 AM
hi thanks it works perfectly

Thanks alot

lucas
10-26-2007, 09:36 AM
Please mark your thread solved using the thread tools at the top of the page...