Inserting a clock into an Excel cell

  • Thread starter Thread starter Carsten Bauer
  • Start date Start date
C

Carsten Bauer

Hiya

I'm trying to put a clock in a spreadsheet that updates once a minute.
I'm using the =NOW() formula, but it doesn't always update every
minute. Any ideas on how to make excel update a spreadsheet's cell
automatically?


Thanks

ps. Is there a way of making Excel automatically update a spreadsheet,
without human interferance? LIke making it press F9 automatically for
you?
 
Carsten

The code will go into a VBA code module in your workbook and be run by
assigning the macros to buttons or shortcut keys or by running it
automatically.

Read Chip's instructions carefully to see where the code will be placed and
how to run the code.

See David McRitchie's site "Getting started with macros" for instructions and
basics of installing and running macros in Excel.

http://www.mvps.org/dmcritchie/excel/getstarted.htm

Gord
 
Hiya

I'm trying to put a clock in a spreadsheet that updates once a minute.
I'm using the =NOW() formula, but it doesn't always update every
minute. Any ideas on how to make excel update a spreadsheet's cell
automatically?


Thanks

ps. Is there a way of making Excel automatically update a spreadsheet,
without human interferance? LIke making it press F9 automatically for
you?
Click to expand...


Thank you all for your assistance, I took the plunge after a friend
showed me visual basic 6.
I started working on it, downloaded a few ebooks and started weaving
my magic. I now have my project finished and it's working great.

Thank you again.
 
Back
Top