+ Reply to Thread
Results 1 to 6 of 6

real time

  1. #1
    Registered User
    Join Date
    06-23-2009
    Location
    saudi
    MS-Off Ver
    Excel 2003
    Posts
    20

    real time

    Hello
    Is it possible to get a time clock in a cell e.g. A1 that update along with the system clock.

  2. #2
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: real time

    yes but it will forever clear your undo options
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula

    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC

  3. #3
    Registered User
    Join Date
    06-23-2009
    Location
    saudi
    MS-Off Ver
    Excel 2003
    Posts
    20

    Re: real time

    Quote Originally Posted by martindwilson View Post
    yes but it will forever clear your undo options
    You mean i cant undo my mistakes or the undo botton in toolbar will be gone

  4. #4
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: real time

    every time it changes the undo stack gets cleared, so your undo/redo options will grey out

  5. #5
    Registered User
    Join Date
    06-23-2009
    Location
    saudi
    MS-Off Ver
    Excel 2003
    Posts
    20

    Re: real time

    Quote Originally Posted by martindwilson View Post
    every time it changes the undo stack gets cleared, so your undo/redo options will grey out

    its ok, can you show me how to do it?

  6. #6
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: real time

    Perhaps one of Andy's toys could help without clearing the stack. Worth a look.

    http://www.andypope.info/fun/clocks.htm
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1