Results 1 to 6 of 6
  1. #1
    4 Star Lounger
    Join Date
    Dec 2003
    Location
    Perth, Western Australia, Australia
    Posts
    487
    Thanks
    75
    Thanked 2 Times in 1 Post
    Lounger,

    Anyone know how to make a cell flash based on a value range, ie if cell A1 is between 5 & 10 make it flash on and off red.

    Thanks for any help

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    See the topic Animate text for some ideas, but please read my warning against doing this.

  3. #3
    4 Star Lounger
    Join Date
    Dec 2003
    Location
    Perth, Western Australia, Australia
    Posts
    487
    Thanks
    75
    Thanked 2 Times in 1 Post
    Thanks Hans - will have a look

  4. #4
    New Lounger
    Join Date
    Jan 2010
    Location
    L.A.
    Posts
    10
    Thanks
    2
    Thanked 0 Times in 0 Posts
    I tried the PCMagazine macro for flashing Excel text.

    The 2nd line in the macro, namely:
    Public Const FR As String = "Sheet1!A1"

    generates compile error msg:

    "Constants, fixed-length strings, and Declare statements not allowed as Public members of object modules."

    Can you tell me how to fix that? Thanks for any help. I know you are busy.

    John

  5. #5
    5 Star Lounger AndrewKKWalker's Avatar
    Join Date
    Apr 2001
    Location
    Cambridge, UK
    Posts
    1,020
    Thanks
    0
    Thanked 3 Times in 3 Posts
    Quote Originally Posted by j rice View Post
    The 2nd line in the macro, namely:
    Public Const FR As String = "Sheet1!A1"

    generates compile error msg:

    John
    It is a constant so needs to be

    Code:
    Public Const FR = "Sheet1!A1"
    The data type of a constant is implicit within the declaration so it does not need the AS Declaration

    I'd still go with the earlier comment to avoid flashing with Timer Events.
    It opens a can of possible user interaction worms.

    Indeed on a bad day it can create a workbook that keeps opening when it is closed.
    I saw this behaviour quite recently.
    Andrew

  6. #6
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    Although the type declaration is optional, I think it's better practice to include it, FWIW.

    It sounds to me as though you have put the variable declaration somewhere other than a normal module, so you need to move it to a normal module.
    Regards,
    Rory

    Microsoft MVP - Excel

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •