13 thoughts on “Downloads”

• Pingback: How to make a cell flash in Excel and why I wouldn't do it!

• Pingback: How to use the VLOOKUP Function in Excel | ExcelSuperSite

• 

  Chijioke Osuji March 20, 2016 at 2:07 am

  I wasn’t able to apply the flash on more than one cell on a sheet, any help!

  • 

    Brian March 20, 2016 at 1:47 pm

    Hi Chijioke,

    To apply the flash on to more than one cell you need to modify the cell range in the VBA code.

    In the VBA Editor, if you open up “Module 1” simply change the cell range portion of the code:

    Public Const FlashRng As String = “Sheet1!A3”

    to reflect the cells you want to flash. Something like:

    Public Const FlashRng As String = “Sheet1!A3:A5”

    will make the cells A3 through to A5 flash.

    Cheers,
    Brian

    • 

      Chijioke Osuji March 21, 2016 at 5:00 am

      Thank you Brian,

      The solution was effective. I also used comma (,) to flash new cells separately.
      How can i make my some one else see the flash from his end. After saving the work, the flash seem not to be active. I am sure i did need more info concerning compatibility during saving

      • 

        Brian March 21, 2016 at 9:03 am

        Hi Chijioke,

        Glad you were able to get it sorted. Regarding your spreadsheet not working for the other person – 2 things to initially check:
        1. Did you save your spreadsheet as a Macro Enabled spreadsheet (*.xlsm or *.xlsb)?
        2. Has the other person enabled macros on their computer? Macro MUST be enabled in order for the code to be able to be run.

        • 

          Chijioke Osuji March 21, 2016 at 2:30 pm

          Thank you Brian,

          I did saved my work with macro enabled spreadsheet and closed up. But unfortunately, when i opened it to check, the flash was not active. I had to click on run to activate it.
          I need this for my stock report. the flash is intended to call the attention of my procurement manager in another location. The point is that even as i sent the report via email, with macro enabled system, he should be able to see the flash as soon as he opens the report. the flash should call his attention to the urgent stock replacement

          Can i have your email ID so that i can send you a report i prepared with flash?

        • 

          Brian March 21, 2016 at 2:51 pm

          Hi Chijioke,

          The code as it is in the article is not set up to automatically start as soon as the spreadsheet is opened.

          To get the code to run as soon as your workbook is opened, add the following lines of code into the “ThisWorkbook” module in the VBA Editor.

          Sub Workbook_Open()
          Call StartFlashing
          End Sub

          This code will call the StartFlashing sub routine as soon as your spreadsheet is open and hence your cell(s) that you specified will flash.

          If you have any further queries, please send me an email at support@excelsupersite.com

          Best Regards,
          Brian

        • 

          Chijioke Osuji March 21, 2016 at 8:35 pm

          Dear Brian,
          Thank you for your swift response.
          I sent you an email.

          Thanks

        • 

          Chijioke Osuji March 22, 2016 at 12:09 am

          Dear Brian,
          PLEASE can you respond to my email?

          Chijioke

• 

  Kaz November 17, 2016 at 6:13 am

  Thanks for your tremendous effort, I’d really appreciate. My Boss was amazed with Flash.

  But I have an issue please, I have different work sheets. I was only able to make it work one sheets. The other one I tried it’s disrupt the whole thing. Please help.

  Same workbook but different sheets.

  Thanks once again.

• 

  Robert Li January 9, 2018 at 5:09 pm

  Brilliant! Your Loan Amortization Schedule Calculator is a lifesaver

  Have you any more sort of budgeting templates being added?

  • 

    Brian January 10, 2018 at 3:15 pm

    Hi Robert, That’s great you loved the Loan Amortisation Calculator. Re: budgeting templates, we are adding more templates all the time – any particular template you would like to see? Let us know and we’ll see what we can create for you.
    Cheers,
    Brian

Comments are closed.