+ Reply to Thread
Results 1 to 8 of 8

automatic change color of cell every 5 second

  1. #1
    Forum Contributor
    Join Date
    11-18-2014
    Location
    alex
    MS-Off Ver
    excel
    Posts
    135

    automatic change color of cell every 5 second

    I want vba code which change back color of b2 between “yellow color,green,orange” every 5 seconds

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: automatic change color of cell every 5 second

    See Help for the Application.OnTime method.
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Forum Contributor
    Join Date
    11-18-2014
    Location
    alex
    MS-Off Ver
    excel
    Posts
    135

    Re: automatic change color of cell every 5 second

    I can't understand where the solution .sorry

  4. #4
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,404

    Re: automatic change color of cell every 5 second

    Paste this code into the sheet level module :


    Please Login or Register  to view this content.
    Attached Files Attached Files

  5. #5
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: automatic change color of cell every 5 second

    Hello sterio,

    Maybe you would like to try this alternative;

    Please Login or Register  to view this content.
    Regards.
    Attached Files Attached Files
    Please consider:

    Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .

  6. #6
    Forum Contributor
    Join Date
    11-18-2014
    Location
    alex
    MS-Off Ver
    excel
    Posts
    135

    Re: automatic change color of cell every 5 second

    1000000000000 thanks to winon& 1000 thanks to logit :D AS WINON CODE IS better

  7. #7
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,404

    Re: automatic change color of cell every 5 second

    1000000000000 thanks to winon& 1000 thanks to logit :D AS WINON CODE IS better

    Oh ... oh .... I'm hurt. Perhaps, even bleeding a little.

    My totals :
    Posts 1,043

    Winon's totals :
    Posts 4,478


    Me thinks there is something amiss ! Ne'er ... this shall not go unanswered Sir !
    A duel ! I demand my just recompense. Tomorrow at high noon on the front lawn.

    Your choice of pistols ....

    (and to think all of this was due to an extra two silly buttons)

  8. #8
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: automatic change color of cell every 5 second

    @ Logit,

    You have to learn how to lose before you can win!LOL

    I accept your request for just recompense, as I am humiliated and hurt by your arrogant and insensitive comment, quote, "(and to think all of this was due to an extra two silly buttons)", end quote.

    Forget the pistols since I am a renowned marksman, which will be a too easy way for you to pass on from your miserable life thus far. I choose you to suffer the most horrendous painful demise by my deadly hands, faster than lightning inflicting the worse pain you could ever imagine, until you will rather choose to depart out of free will.

    Your choice!

    Thank you for the Rep sterio.

    Cheers guys!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Automatic change background color depending on cell value
    By Surferdude949 in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 05-22-2015, 08:02 PM
  2. Automatic color change of a rectangle when cell changes.
    By pauldobie1966 in forum Excel General
    Replies: 2
    Last Post: 03-17-2015, 08:04 AM
  3. Automatic Text Color Change?
    By newguy91401 in forum Excel General
    Replies: 1
    Last Post: 07-16-2009, 02:40 PM
  4. Automatic Color Change
    By Chris in forum Excel General
    Replies: 4
    Last Post: 03-30-2006, 04:25 AM
  5. [SOLVED] How do I change the format/cell/border/automatic color to black
    By tanya in forum Excel General
    Replies: 1
    Last Post: 03-06-2006, 04:10 PM
  6. RE: Automatic Color Change
    By Gary''s Student in forum Excel General
    Replies: 0
    Last Post: 02-04-2006, 03:10 PM
  7. HOW DO I CHANGE THE AUTOMATIC BORDER COLOR IN EXCEL?
    By mhbento in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-16-2005, 06:06 PM

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