Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How the content of a cell in excel blinking continusly ? | Excel Discussion (Misc queries) | |||
how do i format a cell with blinking option in excel | Excel Discussion (Misc queries) | |||
How do I add a blinking effect to cell in an Excel spreadsheet? | Excel Discussion (Misc queries) | |||
How do I create a blinking cell or line in EXCEL? | Excel Discussion (Misc queries) | |||
What is the formula for blinking a cell with a value in Excel | Excel Worksheet Functions |