ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   blinking cell= in ms excel (https://www.excelbanter.com/excel-programming/284413-blinking-cell%3D-ms-excel.html)

Oyku Ozen

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



Tom Ogilvy

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





[email protected]

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