Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 172
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How the content of a cell in excel blinking continusly ? Thanasis Excel Discussion (Misc queries) 2 October 28th 08 04:26 PM
how do i format a cell with blinking option in excel Shahbaz Excel Discussion (Misc queries) 2 May 4th 08 09:39 AM
How do I add a blinking effect to cell in an Excel spreadsheet? Fabz Excel Discussion (Misc queries) 2 September 14th 07 05:53 PM
How do I create a blinking cell or line in EXCEL? Helmut1946 Excel Discussion (Misc queries) 1 August 27th 07 08:12 PM
What is the formula for blinking a cell with a value in Excel SN Excel Worksheet Functions 2 December 16th 05 04:09 PM


All times are GMT +1. The time now is 04:43 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"