May 21 2024 10:24 AM
Is it possible to write a macro that causes a cell value to flash or blink if the cell value fails to meet a maximum or minimum value?
May 21 2024 11:34 AM
Instead of flashing or blinking (which can be dangerous for some users, and irritating to others), you can use conditional formatting to make the cell stand out - you can change the cell's font style, fill color and/or borders.
May 21 2024 11:38 AM
May 21 2024 01:16 PM
It's possible, but I still strongly recommend against it. It would require VBA code to run every second or so, and this will most likely interfere with the normal operation of the workbook.
May 21 2024 01:22 PM
I will heed your advice. However, just for my curiosity, what would the macro look like? If it's not unreasonable to send it, can you send it to me?
May 21 2024 01:42 PM
See the attached demo workbook. There is code in three places:
One of the side effects that you'll notice is that you'll be asked to save the workbook each time you close it even if you didn't change anything.
May 21 2024 02:47 PM
May 21 2024 02:50 PM
Yes.
Change the values of the constants dblMin and dblMax for your situation, and change the function rngCell to return the cell that you want to flash. These are all in Module1.
May 21 2024 02:55 PM