![]() |
blinking cell= in ms excel
Hi,
I would like to get informed about the opportunity in MS Excel to make some specified cells blinked.. I am waiting your assist, thank you, Oyku |
blinking cell= in ms excel
A previous suggestion by Bill Manville:
There is no built-in way to get a flashing colour. If it is a particular cell that you want to test, try something like this Here's one way. Just select colour 10 for the font of the cells you want to flash. Unfortunately the whole screen is redrawn so the cell flashing is not as significant as you would like: Dim NextTime As Date Sub Flash() If ActiveWorkbook.Colors(10) = RGB(255, 0, 0) Then ActiveWorkbook.Colors(10) = RGB(0, 255, 0) Else ActiveWorkbook.Colors(10) = RGB(255, 0, 0) End If NextTime = Now + TimeValue("00:00:01") Application.OnTime NextTime, "Flash" End Sub Sub Auto_Close() Application.OnTime NextTime, "Flash", schedule:=False End Sub -- Bill Manville Oxford, England Microsoft MVP - Excel -- Regards, Tom Ogilvy "Oyku Ozen" wrote in message ... Hi, I would like to get informed about the opportunity in MS Excel to make some specified cells blinked.. I am waiting your assist, thank you, Oyku |
blinking cell= in ms excel
Here's a suggestion from Bill Manville.
http://www.google.com/groups?threadm...oswest.msn.net HTH Paul -------------------------------------------------------------------------------------------------------------- Be advised to back up your WorkBook before attempting to make changes. -------------------------------------------------------------------------------------------------------------- Hi, I would like to get informed about the opportunity in MS Excel to make some specified cells blinked.. I am waiting your assist, thank you, Oyku |
All times are GMT +1. The time now is 08:50 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com