Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 7 of 7

Thread: Flashing Text In A Cell

  1. #1
    Join Date
    25th August 2005
    Location
    Wakefield / UK
    Posts
    66

    Flashing Text In A Cell

    Hello,

    This might sound daft, but im just wondering if it is possible to Flash text 2 different colours in a cell.

    Cell A1 will say - - - Well done
    and I want it to flash blue and red, but not use VBA to do it.

    Can it be done or am I wishful thinking? This would be on Office 97.

    Thanks

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    20th February 2006
    Location
    London, UK
    Posts
    2,955

    Re: Flashing Text In A Cell

    I very much doubt you can do it without VBA.

    Excel Video Tutorials / Excel Dashboards Reports


  3. #3
    Join Date
    28th June 2005
    Location
    Lincolnshire, UK
    Posts
    1,137

    Re: Flashing Text In A Cell

    Only way I can think of would be to use conditional formatting based upon the second of the time. Normally use the mod 2 to alternate the color. Only issues then is with calculation.
    Rich

    www.imits.co.uk - for all your training and development needs!

  4. #4
    Join Date
    25th August 2005
    Location
    Wakefield / UK
    Posts
    66

    Re: Flashing Text In A Cell

    Quote Originally Posted by Badger101
    Only way I can think of would be to use conditional formatting based upon the second of the time. Normally use the mod 2 to alternate the color. Only issues then is with calculation.
    Thanks, I dont suppose you could give an exaple could you? Im not sure exactly what you mean.

    Excel Video Tutorials / Excel Dashboards Reports


  5. #5
    Join Date
    7th March 2003
    Location
    Essex, England
    Posts
    11,310

    Re: Flashing Text In A Cell

    VBA solution only.
    Blinking text

    But I strongly advise against it.

    Cheers
    Andy


  6. #6
    Join Date
    20th February 2006
    Location
    London, UK
    Posts
    2,955

    Re: Flashing Text In A Cell

    Prompted by Badger's suggestion, this is the closest I could get but it's hardly flashing and only seems to update if you refresh or select the cell. Perhaps it can be improved upon
    CF formula is:
    =MOD(SECOND(NOW()),2)=0
    and change the text colour.

    Excel Video Tutorials / Excel Dashboards Reports


  7. #7
    Join Date
    26th January 2003
    Location
    Derbyshire,UK
    Posts
    18,314

    Re: Flashing Text In A Cell

    You can do it with VBA.
    VB:
    Option Explicit 
     
    Public RunWhen As Double 
     
    Sub StartBlink() 
        If Range("k8").Interior.ColorIndex = 3 Then 
            Range("k8").Interior.ColorIndex = 6 
        Else 
            Range("k8").Interior.ColorIndex = 3 
        End If 
        RunWhen = Now + TimeSerial(0, 0, 1) 
        Application.OnTime RunWhen, "StartBlink", , True 
    End Sub 
     
    Sub StopBlink() 
        Range("k8").Interior.ColorIndex = xlAutomatic 
        Application.OnTime RunWhen, "StartBlink", , False 
    End Sub 
    
    
    Hope that Helps

    Roy

    For free Excel tools & articles visit my web site

    If I have helped you and you feel like putting your hand in your pocket please make a donation to Children in Need

    RoyUK's Web Site

    royUK's Database Form

    Where to paste code from the Forum

    About me.

Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Flashing cell & picture load additional code
    By FloggingDolphin in forum EXCEL HELP
    Replies: 5
    Last Post: July 28th, 2006, 04:31
  2. flashing a cell
    By BRAD in forum EXCEL HELP
    Replies: 6
    Last Post: September 2nd, 2005, 01:58
  3. Hidden Sheets Flashing
    By Bari in forum EXCEL HELP
    Replies: 3
    Last Post: January 31st, 2005, 06:49
  4. Flashing screens during a macro
    By ttjolley in forum EXCEL HELP
    Replies: 4
    Last Post: October 1st, 2004, 00:28
  5. Replies: 2
    Last Post: July 30th, 2003, 19:02

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
  •  
porno