+ Reply to Thread
Results 1 to 8 of 8

Blink Cells if condition met

  1. 03-19-2014, 11:07 PM #1
    albert28
    albert28 is offline
    Forum Contributor
    Join Date
    03-09-2010
    Location
    Philippines
    MS-Off Ver
    Excel 2007
    Posts
    235

    Blink Cells if condition met

    Hi Guys,

    Anyone here knows how to make blinking effects vba on the cell, if cell A1:A300 have FAILED value?

    thanks in advance.
    Reply With QuoteRegister To Reply
  2. 03-20-2014, 12:41 AM #2
    :) Sixthsense :)
    :) Sixthsense :) is offline
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,770

    Re: Blink Cells if condition met

    Don't know about 2013. But until 2010 blinking a cell requires VBA with timer which is not suggestible approach from my point of view


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved

    If the suggestion helps you, then Click *below to Add Reputation
    Reply With QuoteRegister To Reply
  3. 03-20-2014, 01:17 AM #3
    Winon
    Winon is offline
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Blink Cells if condition met

    Hello albert28,

    I agree with Sithsense, on this one.

    Why don't you just apply Conditional Formatting for this issue?

    Regards
    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] .
    Reply With QuoteRegister To Reply
  4. 03-20-2014, 02:15 AM #4
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,929

    Re: Blink Cells if condition met

    Im with the other 2, but if you are really set on this, see if this link will help?

    http://excel.tips.net/T002134_Flashing_Cells.html
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford
    Reply With QuoteRegister To Reply
  5. 08-17-2019, 11:17 AM #5
    Biplab950
    Biplab950 is offline
    Registered User
    Join Date
    02-08-2019
    Location
    https://t.me/pump_upp
    MS-Off Ver
    2010
    Posts
    2

    Re: Blink Cells if condition met

    Is it solved or still remain pending?
    Reply With QuoteRegister To Reply
  6. 08-17-2019, 06:21 PM #6
    Winon
    Winon is offline
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Blink Cells if condition met

    Hello Biplab950,

    Reread this Thread and follow the link FDibbins has provided in Post No. 4
    Reply With QuoteRegister To Reply
  7. 08-17-2019, 11:54 PM #7
    Biplab950
    Biplab950 is offline
    Registered User
    Join Date
    02-08-2019
    Location
    https://t.me/pump_upp
    MS-Off Ver
    2010
    Posts
    2

    Re: Blink Cells if condition met

    Please show the Syntax, Sir.
    Reply With QuoteRegister To Reply
  8. 08-17-2019, 11:56 PM #8
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,929

    Re: Blink Cells if condition met

    Quote Originally Posted by Biplab950 View Post
    Please show the Syntax, Sir.
    You just need to follow the link in post #4.

    If you still have a problem, Administrative Note:

    Welcome to the forum.

    We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

    Please see Forum Rule #4 about hijacking and start a new thread for your query.

    If you are not familiar with how to start a new thread see the FAQ: How to start a new thread
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Can't get cells to blink!
    By questionguy in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-22-2012, 05:15 PM
  2. Make specific cells blink
    By questionguy in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-22-2012, 10:04 AM
  3. VBA for Make a cell blink if Condition True
    By santosh226001 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-30-2012, 03:22 AM
  4. Entire Row Blink when condition meet
    By waqarqrl in forum Excel General
    Replies: 9
    Last Post: 08-06-2012, 02:28 PM
  5. Formatting cells to blink or move
    By Therese in forum Excel General
    Replies: 3
    Last Post: 12-18-2005, 05:50 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1