Re: blinking cell?

From: Rob van Gelder (newsgroups_at_nojunkmail-vangelder.co.nz)
Date: 06/12/04 

Date: Sat, 12 Jun 2004 22:15:44 +1200

I'm a developer, not a user. I'll never build blinking into my spreadsheets
so it's not really that much an issue for me.

There's a stop macro already - perhaps you missed it.
Good point about the undo and *** references. Undo is certainly an issue
I'm not prepared to find a solution to. 

-- 
Rob van Gelder - http://www.vangelder.co.nz/excel
"Frank Kabel" <frank.kabel@freenet.de> wrote in message
news:euhc6KFUEHA.712@TK2MSFTNGP11.phx.gbl...
> Hi Rob
> I'm one of these people <vbg>
> Just some comments:
> - Blinking currently requires the usage of the OnTime method. So
> there's a macro running constantly in the background. You also loose
> the ability of 'Undo' your manuall actions in this case
> - You also have to include a 'Stop' macro
> - In addition to your code you should add a specific work***
> reference. Otherwise changing the active sheets will result that A1
> blinks also on the new active ***
>
> Personal thought: As this feature is requested quite often MS wll
> probably include this in a furutre Excel release ;-)
>
>
>
> --
> Regards
> Frank Kabel
> Frankfurt, Germany
>
>
> Rob van Gelder wrote:
> > Some people around here have some unexplained hatred of blinking
> > cells. Often colour and formatting overuse accompanies bad
> > spread*** design. To me these are separate issues, so here's how to
> > get blinking...
> >
> > Check out my website for "Schedule a macro to run"
> >
> > Include something like:
> > Sub RunMe()
> >     With Range("A1").Font
> >         If .ColorIndex = 3 Then .ColorIndex = 4 Else .ColorIndex = 3
> >     End With
> >     ScheduleNextEvent
> > End Sub
> >
> > or if you want the background to blink: With Range("A1").Interior
> >
> >
> > "Martyn" <eser@cc.emu.edu.tr> wrote in message
> > news:OSZNQpEUEHA.1260@TK2MSFTNGP11.phx.gbl...
> >> Hi,
> >> Can we achieve this via plain formula or VBA?. I need to have a
> >> custom conditional formatting (blinking background colour or
> >> highlighting going on/off) for cells that fulfill a certain
> >> condition. Any solution ideas are most wellcomed.
> >> TIA
> >>
> >>
> >>
> >> ---
> >> Outgoing mail is certified Virus Free.
> >> (Giden posta virüssüz olarak belgelendi.)
> >> Checked by AVG anti-virus system (http://www.grisoft.com).
> >> Version: 6.0.703 / Virus Database: 459 - Release Date: 10.06.2004
>