+ Reply to Thread
Results 1 to 5 of 5

Make cell flash a specified number of times upon event

  1. #1
    Forum Contributor
    Join Date
    10-03-2015
    Location
    North Carolina, USA
    MS-Off Ver
    Office 365
    Posts
    167

    Make cell flash a specified number of times upon event

    I am building a template in which people are to paste data into one sheet, and then navigate to a different sheet.

    I want to call the user's attention to a specific cell (M2) on a sheet called "Pivot" as soon as they click on the sheet tab.

    How can I make it so that M2 in Pivot flashes three times as soon as the user activates the sheet?

    Alternatively, I might prefer that M3 has a flashing border around it, but I'm sure I'll be able to figure that out if I can get help with the flashing cell M2.

    I found this code, and tried to adapt it to my needs, but was not successful:



    Please Login or Register  to view this content.

    Thanks for all help.
    Last edited by Pepe Le Mokko; 04-03-2020 at 02:28 AM.

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,453

    Re: Make cell flash a specified number of times upon event

    Hi
    pleaser use code tags instead of HTML tags ( they do not allow scrolling). I have changed them for you

  3. #3
    Forum Contributor
    Join Date
    10-03-2015
    Location
    North Carolina, USA
    MS-Off Ver
    Office 365
    Posts
    167

    Re: Make cell flash a specified number of times upon event

    Thank you, and sorry for the mistake.

  4. #4
    Forum Contributor
    Join Date
    10-03-2015
    Location
    North Carolina, USA
    MS-Off Ver
    Office 365
    Posts
    167

    Re: Make cell flash a specified number of times upon event

    Anybody? Set me off in the right direction?

  5. #5
    Forum Expert BMV's Avatar
    Join Date
    01-13-2020
    Location
    St-Petersburg, Russia
    MS-Off Ver
    2013-2016
    Posts
    1,329

    Re: Make cell flash a specified number of times upon event

    Please Login or Register  to view this content.
    But if deactivate sheet then the ontime must be canceled and cell color return back.
    Last edited by BMV; 04-04-2020 at 02:17 PM.

+ 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. How to make a cell flash
    By Randallovich in forum Excel General
    Replies: 0
    Last Post: 01-27-2015, 08:08 AM
  2. [SOLVED] how to make msgbox appear number of times if value add in a cell
    By sspreyer in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 08-24-2013, 10:59 AM
  3. Replies: 10
    Last Post: 08-17-2012, 07:24 AM
  4. make a cell flash loop
    By dccd01 in forum Excel General
    Replies: 2
    Last Post: 03-13-2010, 01:17 PM
  5. [SOLVED] How do I make the cell flash on and off ?
    By Hurricaine in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-15-2006, 02:25 PM
  6. make a cell flash
    By dwdw1 in forum Excel General
    Replies: 4
    Last Post: 12-19-2005, 11:30 AM
  7. [SOLVED] how to make cell content to flash
    By Woytek in forum Excel General
    Replies: 2
    Last Post: 09-21-2005, 04:05 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