Thread: timer ticker
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Basil Basil is offline
external usenet poster
 
Posts: 60
Default timer ticker

Hiya,

I need a cell in my worksheet (A4) to always show the current time (to the
minute). All I want to do is get excel to calculate every 60 seconds.

I've tried all sorts and using Pearson's stuff with application.ontime on
various options like workbook open, worksheet activate etc etc, but it don't
do sheet if you know what I mean.

I've also looked into 'timer' but I can't figure out how to make it work for
me.

It's is so so so so so so darned simple what I'm asking for... I'm
absolutely shocked I can't find it when I've searched everywhere on here for
it!

Can you help please?

Frustrated B