+ Reply to Thread
Results 1 to 5 of 5

Random Color Change

  1. #1
    Forum Contributor
    Join Date
    01-08-2013
    Location
    Jacksonville, Fl
    MS-Off Ver
    Excel 2016
    Posts
    355

    Random Color Change

    Hello,

    The code below is a running timer that updates every second. I was wondering if it's possible to change the color index number randomly every second it updates so that way the timer consistently changes color?

    Please Login or Register  to view this content.
    Thank you,

  2. #2
    Forum Contributor
    Join Date
    01-08-2013
    Location
    Jacksonville, Fl
    MS-Off Ver
    Excel 2016
    Posts
    355

    Re: Random Color Change

    I think I just realized that this is much more difficult than i thought it would be.

  3. #3
    Registered User
    Join Date
    04-04-2013
    Location
    Here
    MS-Off Ver
    Excel 2010/2013
    Posts
    8

    Re: Random Color Change

    Hi,

    Try:

    Please Login or Register  to view this content.
    V-B-A

  4. #4
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,523

    Re: Random Color Change

    Change to
    Please Login or Register  to view this content.
    I recommend not use "Timer" as a procedure name since it is a vb reserved word.

  5. #5
    Forum Contributor
    Join Date
    01-08-2013
    Location
    Jacksonville, Fl
    MS-Off Ver
    Excel 2016
    Posts
    355

    Re: Random Color Change

    Both work perfect thank you very much!!

+ 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